How to identify and delete orphan relationships - Support and Troubleshooting

How to identify and delete orphan relationships Issue  Description How to count and delete orphan relationships (cmdb_rel_ci)?

Procedure Here is the script can be used to find the orphan relationship counts:

// Find orphan rel count var ga = new GlideAggregate('cmdb_rel_ci'); ga.addEncodedQuery('parent.sys_class_path=NULL^ORchild.sys_class_path=NULL'); ga.addAggregate('COUNT'); ga.query(); ga.next(); gs.log(ga.getAggregate('COUNT'));

To delete orphan relationship

//delete orphans var gr = new GlideRecord('cmdb_rel_ci'); gr.addEncodedQuery('parent.sys_class_path=NULL^ORchild.sys_class_path=NULL'); //gr.deleteMultiple(); //uncheck when required.