Hello,
I am trying to run the following business rule to update or insert a record into my table: u_lol_databases
I placed the following script in the u_lol_databases business rules. I also used the condition onDisplay.. assuming the table will update the correct count if I view the u_lol_databases table.
//count the number of different sys_class_names in the cmdb_ci_db_ora_instance table
var agg = new GlideAggregate('cmdb_ci_db_ora_instance');
agg.addAggregate('COUNT', 'sys_class_name');
agg.groupBy('sys_class_name');
agg.query();
while (agg.next()) {
var databaseType = agg.sys_class_name.getDisplayValue();
var hierarchy = new GlideRecord('u_lol_databases');
hierarchy.addQuery('u_database_type',databaseType);
hierarchy.query();
var getCount = agg.getAggregate('COUNT', 'sys_class_name');
if (hierarchy.next()) {
hierarchy.u_count = getCount;
hierarchy.update();
} else {
hierarchy.u_database_type = databaseType;
hierarchy.u_count = getCount;
hierarchy.insert();
}
}
I'm not really sure where my logic is wrong. I am fairly new to ServiceNow. 
