Into the unknown - CMDB - Find count of CIs per class based on principal class

[VaranAwesomenow]

Below script generates a count of CIs per class for principal classes configured in ServiceNow.

var principalClass = [];
var classVar = 'class';
var grPrincipalCI = new GlideRecord('cmdb_class_info');
grPrincipalCI.addEncodedQuery('principal_class=true');
grPrincipalCI.query();
while(grPrincipalCI.next()) {
principalClass.push(grPrincipalCI[classVar] + '');
}

gs.print("List of principal classes: " + principalClass);

var ciQuery = 'sys_class_nameIN' + principalClass + '';
var count = new GlideAggregate('cmdb_ci');
//count.addQuery('active', '=','true');
count.addEncodedQuery(ciQuery);
count.addAggregate('COUNT', 'sys_class_name');
count.query();
while (count.next()) {
var className = count.sys_class_name;
var classCount = count.getAggregate('COUNT', 'sys_class_name');
//gs.info("There are currently " + classCount + " CMDB with a class of " + className);
gs.info(className + "|" + classCount);
}

Sample output

*****************

*** Script: List of principal classes: cmdb_ci_ip_router,cmdb_ci_alias,cmdb_ci_win_cluster,cmdb_ci_esx_server,cmdb_ci_win_server,cmdb_ci_unix_server,cmdb_ci_datastore,cmdb_ci_lb_bigip,cmdb_ci_netgear,cmdb_ci_firewall_device_juniper,cmdb_ci_storage_hba,cmdb_ci_chassis_server,cmdb_ci_solaris_server,cmdb_ci_ip_switch,cmdb_ci_ip_firewall,cmdb_ci_wan_accel_network,cmdb_ci_firewall_device_cisco,cmdb_ci_unix_cluster,cmdb_ci_lb_a10,cmdb_ci_lb_network,cmdb_ci_backup_server,cmdb_ci_storage_pool,cmdb_ci_linux_server,cmdb_ci_storage_device,cmdb_ci_lb,cmdb_ci_ucs_chassis,cmdb_ci_nas_file_system,cmdb_ci_storage_server,cmdb_ci_network_circuit,cmdb_ci_ucs_equipment,cmdb_ci_firewall_network,cmdb_ci_datacenter,cmdb_ci_san_disk
*** Script: cmdb_ci_alias|1
*** Script: cmdb_ci_backup_server|2
*** Script: cmdb_ci_datacenter|116
*** Script: cmdb_ci_esx_server|8
*** Script: cmdb_ci_ip_firewall|62
*** Script: cmdb_ci_ip_router|1984
*** Script: cmdb_ci_ip_switch|25
*** Script: cmdb_ci_lb|278
*** Script: cmdb_ci_lb_network|2
*** Script: cmdb_ci_linux_server|4187
*** Script: cmdb_ci_netgear|1981
*** Script: cmdb_ci_network_circuit|1
*** Script: cmdb_ci_solaris_server|13
*** Script: cmdb_ci_unix_cluster|3
*** Script: cmdb_ci_unix_server|2
*** Script: cmdb_ci_win_cluster|3
*** Script: cmdb_ci_win_server|4264