- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2025 06:21 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2025 12:50 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago - last edited 2 hours ago
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...