How do we find out the record, given the sys_id?

upasanamahanta · ‎07-12-2016

Given a sys_id, how do we find to which record the sys_id belongs to?

Chuck Tomasi · ‎07-12-2016

You COULD write a script that goes through sys_db_object and checks each table to see if it can find the record. With over 2,000 tables in a default Helsinki instance, this could take a while. The *untested* script might look something like this:

var mySysId = 'xxxxxxxxxxxxxxxxxxxxx'; // put in your sys_id here

var table = new GlideRecord('sys_db_object');

table.query();


while (table.next()) {

       var gr = new GlideRecord(table.getValue('name'));

       if (gr.get(mySysId)) {

                   gs.log('it looks like it came from ' + gr.getValue('label'));

                   break;

       }

}