How can I get a report on CI (specific types) that don't have a particular relationship with another CI type?

stuboasman · ‎03-30-2017

This will eventually be part of our CMDB Health metrics, but I am starting with a report. We have Servers that are populated by Discovery and have a manually maintained (imported) set of Applications. When it is fully populated we shouldn't have any servers that aren't "doing" anything as defined by it having a "Run::Runs On" relationship with the Applications (class=Application).

I can't find how to view the relationships on a report, any advice?

angeliccharm · ‎04-04-2017

Hey Stu,

Sorry you haven't been able to achieve what you want yet. There's the option to do this based on something from the query builder, but it's pretty limited. Ultimately, a script will be needed so it will have to retrieve the CIs and all related CIs and parse through it for the results you want.

If this is something you need assistance with, please let me know.

View solution in original post

robertmaxwell · ‎03-31-2017

Try https://<instance>.service-now.com/nav_to.do?uri=/sys_report_template.do%3Fsysparm_table%3Dcmdb_rel_ci

stuboasman · ‎03-31-2017

Is there an account/password I should be using to get into the sandbox?

robertmaxwell · ‎03-31-2017

Sorry, didnt mean to post an clickable link.

Replace <instance> with your servicenow instance address. It will take you to a report form where the table is set to the CMDB Relationships

stuboasman · ‎03-31-2017

OK, thanks, I see the report setup now, but I believe this will not do what I want because I am effectively looking for is when a CI (such as a server class) does NOT have a defined relationship of a particular type with another CI (such as an Application class). I would think that this would need to look at the server table and identify where that server does not have such an entry in the cmdb_rel_ci table.

Or am I still missing something?

Stu Boasman