My bad. The script worked on extended tables in cmdb but seems like it doesn't for custom tables.
Fixed the script.
var tableName = 'u_test_extend';
var tableUtil = new TableUtils(tableName);
var parentTables = tableUtil.getTables().toArray();
parentTables.shift();
var parentColumns = [];
for (var i=0; i<parentTables.length; i++) {
var table = parentTables[i];
var grSysParent = new GlideRecord('sys_dictionary');
grSysParent.addEncodedQuery('name=' + table + '^internal_type!=collection^internal_typeISNOTEMPTY');
grSysParent.addOrderBy('column_label');
grSysParent.query();
while(grSysParent.next()) {
parentColumns.push(grSysParent.element.toString());
}
}
var grSysCustom = new GlideRecord('sys_dictionary');
grSysCustom.addEncodedQuery('name=' + tableName + '^internal_type!=collection^internal_typeISNOTEMPTY');
grSysCustom.addOrderBy('column_label');
grSysCustom.query();
var customTableColumns = [];
while(grSysCustom.next()) {
customTableColumns.push(grSysCustom.element.toString());
}
for (var j=0; j<parentColumns.length; j++) {
var x = customTableColumns.indexOf(parentColumns[j]);
if (x > -1) {
customTableColumns.splice(x,1);
}
}
gs.info(customTableColumns);
