Report showing Number of CIs having Null/empty values for few fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-08-2024 11:43 PM
Requirement -> ``Report Showing Count of CIs for a particular field/attributes which does not have values``
I was able to download the cmdb_ci_linux_server as excel and create a report, showing number /count of CI which do not have values for attributes/fields `assigned to`, `location`, `asset tag` etc, but we have to do this for several tables.
Tried creating a Pivot table on SN Reports but there is simply too much records that the Report is throwing a prompt that the Pivot table cannot be created for so many rows and columns.
How to create through SN Reports (Count of CIs missing values for a field)? If so, any links, We do not want to go for creating a complete new dashboard.
I am new to SN and started on cmdb recently, Is there any OOTB already present or any other approach I am missing ?
Hoping to get this: I have to show how many CIs are missing values for attributes/fields. i.e Count in reports.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2024 12:28 AM
Hello,
Did you find a solution to your request?
I'm looking for a solution as well.
The request seems pretty basic but I can't find anything at this stage.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2024 07:57 AM
- I had to download the records and do the analysis
- For few, I made Single Score Report, like for each of attribute for which number of empty record were to be found
- Best - A Pivot table for different class, with filter will also work, here different class and the location=empty details
Multi - Level Pivot table, with filter.