How to get class wise CI count which are active?

[Community Alums]

How to get class wise CI count which are active?

[Muhammad Khan]

Hi,

Use below code in background script.

var count = new GlideAggregate('cmdb_ci');
count.addAggregate('COUNT', 'sys_mod_count');
count.groupBy('sys_class_name');
count.query();   

while (count.next()) {  
  var counts = count.getAggregate('COUNT', 'sys_mod_count');
  var className = count.sys_class_name.getDisplayValue();
  gs.print(className + ' Count= ' + counts);
}

Output