derived9> ALL (null) (null) (null) (null) 148 Using where; Using join buffer7 DERIVED ac ALL PRIMARY,FK_asset_configurations_servers_id (null) (null) (null) 229 Usingwhere; Using temporary; Using filesort
7 DERIVED es ref
对于表cmdb_rel_ci,我希望检索唯一的parent.sys_class_name,计数为"type=In Rack::type=In count“。我正在进行开箱即用的练习。var count = new GlideAggregate('cmdb_rel_ci');
count.addQuery('type','e76b8c7b0a0a0aa70082c9f7c2f9dc64');// sys_id of type In Ra
有两列,"IP地址CMDB“,包含IP地址和另一列称为"IP地址LM”。我试图在"IP地址LM“中查找属于"IP地址CMDB”的IP地址,如果"IP地址LM“包含该IP地址,则返回ABCD。for col in report: col_num = report[col]
for num inif report["IP Address LM"].str.co