How to use Business Service as the interactive filter to filter business services?

[Robert Campbell]

We have a list widget of business services.  I am able to filter this list based on Managed by, Assigned to, Supported by and others but how do I filter this by business service?

There is no option to choose name because it isn't referencing anything.

 Sys ID doesn't work either although it is there.

Oddly enough, I can't use the CI Relationship table either because the parent and child could be something other than a business service.

Not sure why this one doesn't work either.

The goal is to be able to choose a business service or set of business services and have the widgets represent them.  The list will show the list information of the selected business services.  The scores will show those business service(s) count based on those filters.  It works with the other filters (Managed by, Supported by, Assigned to) but I can't figure out how to make this work.

[sachin_namjoshi]

You should configure interactive filter on cmdb_ci table and query only business services with class type filter in cmdb_ci table.

This will work in all of your mentioned user cases.

Regards,

Sachin

[Robert Campbell]

But how do you reference a business service?  It's not a reference.  I want to filter the list of business services by the business services chosen in the filter.  There is no option to filter the list directly from the report widget.

How do I set my references?

[sachin_namjoshi]

This depends on your table on which your report is configured.

e.g If you configured report on incident table, you can query incidents for business service selected in your interactive filter.

Regards,

Sachin

[Robert Campbell]

The report is configured on the Business Service table with doesn't have a reference because it is the reference point.

I do have one report where I do query the Impacted Service of an incident and that shows as expected.  What I'm trying to show in this Business service report are just the business services that are selected in the filter.  Maybe there is no way to do what I'm asking?