Service (or App) Owner's Dashboard

[Bobby Campbell]

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?

[Ankith Sharma]

Hi @Bobby Campbell 

The task, CI tables already give you what you need, so you don’t have to build anything too complex. Since task_cmdb_ci_service and task_cmdb_ci_business_app already link Incidents/Changes to the affected CIs, the simplest approach is to report directly on those and filter based on the applications the viewer owns.

A straightforward setup:

1. Build a report or data source that pulls Incidents/Changes where the related CI belongs to applications owned by the logged-in user.
   (Use whatever field in cmdb_ci_business_app stores your owner/app owner/service owner information.)

2. Add two widgets to the dashboard:
   • Applications impacted by active Incidents
   • Applications impacted by active Changes

Let the existing CI-to-Task relationships handle the mapping instead of trying to combine service maps and ownership logic into one complex query, which usually gets messy.

As long as CI ownership is maintained properly, the dashboard stays accurate with minimal effort.

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

-- Ankit

[Bobby Campbell]

Thank you @Ankith Sharma. Are you saying I will create one report for business apps and a separate one for services? I would like my app owners to see a single view that contains all of their task_services AND task_business apps. 

[Ankith Sharma · Accepted solution]

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

[AndersBGS]

Hi @Bobby Campbell ,

Have you considered to look into digital portfolio management. It sounds very much to what you're looking for.