Need number of record for all tables with name containing "cmdb"

[shessdri]

Hi Team,

I have a requirement to get the records corresponding to each table containing cmdb in name

As in I have 1400 tables whose name contains cmdb, I want info for each table separately , like how many records each table is having.
Can anyone help me with the code OR filter corresponding to this.

Thanks.

[Anand Kumar P]

Hi @shessdri ,

You have to glide record cmdb table parent for all classes

var cmdbRecord = new GlideRecord('cmdb');

cmdbRecord.addQuery('name', 'CONTAINS', 'cmdb');

//cmdbRecord.addQuery('sys_class_name','cmdb_ci_server')--for getting records for each individual class server

while (cmdbRecord.next()) {
var ciname= cmdbRecord.getValue('name');

gs.info('CI Name '+ ciname);
}

Mark it helpful and solution proposed if it serves your purpose.

Thanks,

ANAND

[shessdri]

Hi Anand,

We are looking for tables whose name contains cmdb not the Cis containing name as cmdb.

Need number of record for all 1400 tables with name containing "cmdb", individually, each table contains how many records.

Thanks.

[Dr Atul G- LNG]

Hi @shessdri 

As per list view, these 3 ways are there but when we use contains word it can be many. 

[Akshata T]

@shessdri  Try below code you will get count of records as per the tables containing 'cmdb' in name.

var getTables = new GlideRecord('sys_db_object');
getTables.addEncodedQuery('nameLIKEcmdb');
getTables.query();
while(getTables.next()){
var tablesName = getTables.name;
var glideEachTable = new GlideRecord(tablesName);
glideEachTable.query();
if(glideEachTable.next()){
var rowCount = getTables.name + ':' + glideEachTable.getRowCount();
gs.info(rowCount);
}
}