Find the table name of Table sys id in attachments - Before catalog item submission

[Anish Reghu]

Dear experts,

The Table sys id highlighted in the pic above, how do I find the table name of that sys_id?

It is not sc_cat_item nor is it, sc_cart_item.

This is the attachment entry created before submission of the catalog item.

Regards,

Anish

[Sulabh Garg]

Yes Indeed, Its a brilliant feature.

[Sohail Khilji]

Hi Anish,

You can use the below script which will help you...

var gr = new GlideRecord('sys_db_object');
gr.addQuery('sys_id','YOURSYSID HERE'); 
gr.query();
while(gr.next())
   {
   gs.addInfoMessage(gr.name); //This will give you table name
}

Thanks,

Sohail Khilji

Kindly Mark Correct / Helpful if it address your concern...

[Anish Reghu]

Hi Sohail,

Thanks, but this just scans the sys_id of the tables in ServiceNow.

What I need is - that input be any table record without specifying table name and system returns me the table name.

Regards,

Anish

[Alicia Haag]

On this page, you’ll find a few of the scripts I’ve saved over the years, and maybe a few scripts submitted by our most clever and dashing readers. The scripts you’ll find here, are one-off blocks of code that solve one problem as efficiently as they can. You won’t find detailed deep-dive explanations here, like you would in my articles on the blog; just examples, prototypes, and quick fixes to common coding conundrums. You also won’t find any of the scripts that I’ve already written articles with detailed explanations on, such as the Journal Redactor.

 ReadyPay Online Login

[Anish Reghu]

Thanks for commenting. But, I don't find any hyperlinks in your comment.