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.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Dominik Trui

    Yeah, such SQL queries can be a huge time saver.

    But one has to be very careful and check afterwards if the structure is intact. I tried to “re-link” tasks today. After some updates on the mxp_tasklnk I killed the links of several tasks in the “approve” tree while “re-linking” tasks in the “decline” tree. Luckily only the links and not the tasks themselves, plus it was in the dev system.

    (0) 

Leave a Reply