Business Service Configuration Item Report

[mr_smith]

I've discovered my inventory using Service Now.

I've created relationships between the discovered CIs based on their interactions related to the business service.

I've mapped the Business Service to the linked Cis.

Now I want a report that either lists the CIs and their attributes including the business service(s) they are related to or a list of business services and the Cis related to them.

How is this achieved?

[gyedwab]

Explore Analytics has just released new functionality for Business Service Reporting that allows you to automatically roll up configuration items to Business Services in reports.

This is calculated live, so it'll be up to the minute data directly against ServiceNow.

Here's an example report: Configuration Items with Associated Business Services

The "Parent Service" field condenses the business services into a comma-separated list.

You can do this on any table that has a reference to the CI table, for instance this report on the Outages table: Current Outages for My Services

That outages report filters the upstream Business Services to only show outages where the associated CI belongs to a business service owned by the logged in user:

You can also use the upstream business service to group by in reports: Top Causes of Incident SLA Breach by Business Service and Cause  

[rewanthrr]

Hi,

I am exactly looking for this. Could you please let me know how to fetch such report?

Thanks,

Rewanth

[robertgeen]

Hello Greg,

This is actually one of the more annoying things to do. The best way that I have found to do is using a database view and then reporting off of the database view itself. I'm not entirely sure if it is the best way to do it but it's the only way I have found to do it easily. Essentially you can create joins between the rel table and the business service and server tables. There is another table that semi pre-joins them that you can use as well (it's called svc_ci_assoc I believe) and you can just join on the IDs in there. Below is a link to the wiki that talks about database views and will hopefully help you get started.

Database Views - ServiceNow Wiki

[toneyvecchio1]

Yes I write my database join on Ci relationship table

[bernyalvarado]

Hi Greg,

You may want to give a look to the Service Configuration Item Associations

yourinstanceurl/nav_to.do?uri=/svc_ci_assoc_list.do

Thanks,

Berny