It possible to clear all CI relations from database. I have plan to create new CI relations.
Please help advice for this case.
relationship are stored in the dbo.busmgt table (bmhier object).
as always I discourage to do any directly in the DBMS to avoid bypass the object layer
as you can see below several triggers are attached to this object: and those will not trigger if you do directly in the database or using pdm_load
At less take a backup
Hi jmayer ,
Many thanks for your post.
While this won't remove relationships from the indicated table, it is possible to set relationships inactive using GRLoader:
Remove CI Relationships with GRLoader
We have used the following in a spreadsheet to set the indicated relationship inactive:
Have you done it support922.922? Is it safe?
Can anyone give me some feedback on how to effectively remove (not inactivate) relationships from CMDB?
It is possible to delete them through the interface, so I figured there must be a way to do so using commands or PDM_LOAD.
Didn't find any means through GrLoader. The solution below just inactivates them.
CI Relationships - CA Service Management - 14.1 - CA Technologies Documentation
I use the rest api to delete ci relationships, it's built into a process that runs daily to check for changes in our configuration management tools. You could build a similar process or write a simple script that takes a list of IDs from a CSV and sends delete request to the API.