question Re: How do I pull the parent.sys_class_name in a query? in Developer forum

How do I pull the parent.sys_class_name in a query?

zsquared — Mon, 07 Nov 2016 18:19:28 GMT

Hello,

I am trying to get a count of the parent.sys_class_name in the cmdb_rel_ci table but I do not understand why the script is not working. I used this script previously to just pull sys_class_name from a different table and it had worked so I am not sure why parent.sys_class_name is not working.

Any ideas?

//count number of server instances grouped by sys class name
var agg = new GlideAggregate('cmdb_rel_ci');
agg.addAggregate('COUNT', 'parent.sys_class_name');
agg.groupBy('parent.sys_class_name');
agg.query();
while (agg.next()) {
   var serverType = agg.parent.sys_class_name.getDisplayValue();
   var hierarchy = new GlideRecord('u_land_o_lakes_physical_servers_allocation');
   hierarchy.addQuery('u_allocate_to',serverType);
   hierarchy.query();
   var getCount = agg.getAggregate('COUNT', 'parent.sys_class_name');
   if (hierarchy.next()) {
   hierarchy.u_allocate_to = serverType;
   hierarchy.update();
   } else {
   hierarchy.u_allocate_to = serverType;
   hierarchy.insert();
   }
}

Re: How do I pull the parent.sys_class_name in a query?

bernyalvarado — Tue, 08 Nov 2016 06:38:21 GMT

Hi Zhen,

On line 9, try the following instead:

var serverType = agg.getValue('parent.sys_class_name');

Thanks,

Berny

Re: How do I pull the parent.sys_class_name in a query?

bernyalvarado — Tue, 08 Nov 2016 06:38:50 GMT

I have tried it and it works .

Hope it helps!

Thanks,

Berny

Re: How do I pull the parent.sys_class_name in a query?

zsquared — Tue, 08 Nov 2016 16:21:14 GMT

Thank you! I also realized it was an error in my syntax!