Quick Hint: remove "Copy of " prefixes - Identity Center

[former_member222441]

You are bored of removing  the  "Copy of" prefixes after you have copied identity center drawers with huge content?

The SQL statements below are a quick way.

Drawers

use mxmc_db

update mc_Group

set Group_Name= right(Group_Name, len(Group_Name)-8)

where Group_Name like 'Copy of %'

Tasks

use mxmc_db

update MXP_Tasks

set Taskname= right(Taskname, len(Taskname)-8)

where taskname like 'Copy of %'

Jobs

use mxmc_db

update MC_Jobs

set name= right(name, len(name)-8)

where name like 'Copy of %'

The statements work on SAP IdM 7.1 and 7.2. I am not sure for SAP IdM 8.0.