CA Service Management

  • 1.  Merge Multiple Accounts, CA SDM

    Posted Jun 22, 2017 10:03 AM

    Hey all,

     

    We have a situation where we are now creating all of our accounts via LDAP. However this has been uneven in the past in terms of how we have created accounts into the system. Due to this we are ending up with multiple accounts for a particular user in the system. We don't want to delete the additional account but we also would like to condense all of the information into one current account. 

     

    Is it possible to merge CA SDM account records together? This would seem to be a necessary functionality to have.

     

    Please let me know!

     

    Many thanks



  • 2.  Re: Merge Multiple Accounts, CA SDM

    Posted Jun 22, 2017 10:14 AM

    As far as i know, you cannot merge account, but you can replace every reference to the duplicated users with the "correct" user.

     

     

     

    We had a lot of problem with duplicate contact due to samAccountname modification.

     

    To prevent having additionnal duplicate, we created a script that synchronizes contacts (also building departement location and company).

     

    Then we ran some queries to find duplicate users. 

     

    With the list of duplicated users, you can run sql queries to replace the user in every table you want to.

     

    We did : activity, chg, chg wf, request, incident, problem, issues, issue wf.

     

    Do not forget that data manipulation at a DB level is not supported by CA. (You can always use pdm_extract/load or WS)

     

     

    This is not a solution but it might helps you decide wich way you want to go.