Service (or App) Owner's Dashboard

Bobby Campbell
Mega Sage

We're preparing to roll out service maps and one of the deliverables I'd like to create is an App Owner (eventually, Service Owner) dashboard that shows the viewer: For all apps I own, these are the ones that are listed as being Impacted by an Incident or an active Change.

 

The information is in the task_cmdb_ci_service and task_cmdb_ci_business_app tables, but I'm not sure how to pull it together correctly.  Has anyone been down this road before, and has any feedback or lessons learned?

1 ACCEPTED SOLUTION

Ankith Sharma
Tera Guru

Good question @Bobby Campbell. You can create two separate reports, but if your goal is a single unified view, you don’t have to split them. Both task_cmdb_ci_service and task_cmdb_ci_business_app have a similar structure, so you can bring them together in one of these ways:

Option 1: Use a Report Source (which I would recommend)
Create a Report Source that includes both tables with the common fields you care about (task, CI, state, etc.). Once you have that, you can build a single report that shows all impacted services and business apps owned by the viewer.

Option 2: Use a Dashboard with a Single List Widget
You can also use a list widget pointing to a scripted Filter Source where you query both tables and return a combined result set. This keeps the dashboard clean while giving owners one consolidated view.

Option 3: Two reports on the dashboard (A bit technical)
This is the easiest to set up, but if you really want a single list, go with option 1 or 2.

So yes,  a single view is possible, it just depends on how much effort you want to put into combining the data sources.

If you found this useful, please mark it as Helpful and Accepted.

-- Ankit

View solution in original post

5 REPLIES 5

Hi @AndersBGS 
Found this question when looking for i similar myself.

I also saw your post/comment. Can you explain the function how DPM does this. I.e. show application owners if there are any incidents related to their business applications.

 

Please share how this is possible in DPM.

My post is here:
https://www.servicenow.com/community/incident-management-sow-forum/see-health-of-my-business-applica...