Blog

All CI Classes Currently Used

Here is a background script you can use to find all the CI Classes that are used in your ServiceNow Instance. You can use this script in scripts - background or alter slightly to use a script include for a report.  

Background Script

findCIClassesUsed();
function findCIClassesUsed() {
var count = new GlideAggregate('cmdb_ci');
count.addAggregate('COUNT', 'sys_class_name');
count.query();
while (count.next()) {
var ciClass = count.sys_class_name;
var classCount = count.getAggregate('COUNT', 'sys_class_name');
gs.log("The are currently " + classCount + " configuration items with a class of " + ciClass);
}
}