Service Desk Practitioners Forum
cancel

How to delete imported relations from OVSD 4.5 SP19?

Highlighted
Milan Karban
Respected Contributor.

How to delete imported relations from OVSD 4.5 SP19?

Hi all,

now we're importing data from external systems (MS SMS, AuditPRO) to CMDB in OVSD 4.5 SP19 with relations between CIs automatically. When the CI disappear in source system, it's blocked in CMDB automatically (based on delta report).

But we have problems with imported relations - we need to delete from CMDB relations (parent-child and custom direct relations) that disappear in source system. There isn't anything as "block" relation and I don't know if it's possible to delete relations from command line (in batch) by using sd_import.bat or sd_event.bat when I have CSV with the list of relations that disappeared (whole key in import mapping for relations).

So, now my question: exists any way how to automatically delete relations?

Thanks,

Milan K.
2 REPLIES
Mark O'Loughlin
Acclaimed Contributor.

Re: How to delete imported relations from OVSD 4.5 SP19?

Hi,

as you have found out relations can be made during the import process however there is no automated way to undo the relations.
Milan Karban
Respected Contributor.

Re: How to delete imported relations from OVSD 4.5 SP19?

Hi,

somebody told me that this could be possible via sd_event when I will know the OID of relations to delete in SD database.
Do you think that this is the way?

Thanks,

Milan K.