Report showing Number of CIs having Null/empty values for few fields.

MohammedAsK
Tera Contributor

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.

2 REPLIES 2

fredericgen
Tera Contributor

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.

 

  • 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

MohammedAsK_0-1730735682237.png

MohammedAsK_1-1730735704239.png

Multi - Level Pivot table, with filter.