Thanks - useful to know, that I wasn't missing something on showing index usage.
Yes, I am aware of `sys_db_index` - for Scoped Application we have to also cater for SN custom field references (e.g. a_ref_5, a_str_16) - so my script for this, which converts these, is:
var application = 'My App Scope';
var tableName = 'x_my_app_my_table'; // optional, can comment out
// Application (Scope)
var appr = new GlideRecord('sys_scope');
appr.addQuery('name', application);
appr.query();
appr.next();
appr;
var indexes = [];
var rec = new GlideRecord('sys_db_object');
rec.addQuery('sys_scope', appr.sys_id);
if (typeof tableName != 'undefined' && tableName.length) {
rec.addQuery('name', tableName);
}
rec.orderBy('name');
rec.query();
while (rec.next()) {
var irec = new GlideRecord('v_index_creator');
irec.addQuery('table', rec.sys_id);
irec.addQuery('sys_scope', appr.sys_id);
irec.orderBy('index_name');
irec.orderBy('cols');
irec.query();
while (irec.next()) {
var idx = {};
idx.tname = rec.getValue('name');
idx.name = irec.getValue('index_name');
idx.table = irec.getValue('logical_table_name');
var colNames = irec.getValue('index_col_name');
idx.unconvert_cols = colNames;
var cols = [];
var colParts = colNames.split(',');
colParts.forEach(function(c) {
c = c.trim();
if (c.length && c.startsWith('a_')) {
var srec = new GlideRecord('sys_storage_alias');
srec.addQuery('storage_alias', c);
srec.addQuery('table_name', idx.tname);
srec.query();
if (srec.next()) {
// storage_alias
cols.push(srec.getValue('element_name'));
}
}
else {
cols.push(c);
}
});
idx.cparts = colParts.length;
idx.convert_cols = cols.join();
idx.unique = !!irec.unique_index;
idx.method = irec.getValue('access_method');
indexes.push(idx);
}
}
indexes;
