- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2022 08:08 AM
I am working on creating a Dashboard for ServiceNow Discovery on CMDB Objects
Need to figure out which table to used and how to filter best to use bar chart or list table for the type of report:
1) How many objects are being discovered in Discovery?
2) How many objects are left to be discovered/created by Discovery?
3) How many are still being manually entered/updated by/created by?
4) How to know if it is authenticated and how is it authenticated?
Looking into which tables to pull off of I am currently using the table OOB:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2022 08:23 AM
I highlighted above, Class field cmdb_ci table is going to help filter required classes. Just add Class as one filter condition and call required class name.
Suresh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2022 08:12 AM
Hi,
1. You can use Discovery Source, Most Recent Discovery fields to understand the things.
2 and 3 Use discovery source to understand the left one.
Suresh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2022 08:14 AM
Which table to use can you send a quick screenshot if applicable of how you would go about performing it?
Trying to figure out which table to use is their an all discovery table or I would need to create multiple reports for each different "class name"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2022 08:16 AM
Hi, You can use cmdb_ci table to create the mentioned report and use class as differentiator. Use Pivot table mechanism from the report. It will give the count and when you click the count of each class it will route it to the result as well.
Suresh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2022 08:21 AM
When I type in CMDB_CI for the table it provides quite the list of different tables, which one would you recommend I select or type?