cmdb relationship

shivaadapa
Tera Expert

Hi,

I want to create a report on to know custom cmdb realationship types in my instance ? what type of conditions we have to keep?

5 REPLIES 5

Prabu Velayutha
Mega Sage
Mega Sage

Hi @shivaadapa 

 

First check the cmdb_rel_type table to see the number of custom relationships types created, you can spot the one by seeing the created by attribute, the oobs should have 'admin' or 'glide.maintain' some cases you will find some Servicenow employee user id those were created OOB.  Custom relationship type will show your user id in created by if you created it or your co-workers or your CMDB admins.

 

You create a report on table cmdb_rel_type and set the below sample conditions as filter with created by not contains OOB created by users

 

PrabuVelayutha_0-1700475297203.png

 

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers!