…thoughts on ServiceNow and digital transformation

Post

ServiceNow script for attachment sizes by table


var list = new GlideAggregate("sys_attachment");
//list.addQuery('table_name','IN','cmn_location,incident,alm_hardware,ast_contract,fm_expense_line')
list.groupBy('table_name');
list.addAggregate('SUM', 'size_bytes');
list.addAggregate('COUNT', 'sys_id');
list.query();
while (list.next()){
	gs.info(list.getValue('table_name') +': ' + list.getAggregate('COUNT', 'sys_id') + ' files ' + Math.round(list.getAggregate('SUM','size_bytes') * .000001) + ' MB');

}