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

Anish Reghu
Kilo Sage
Kilo Sage

Dear experts,

find_real_file.png

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

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@Anish Reghu 

It seems you are adding file to some record producer or catalog item during submission

The sysId you are seeing is not any record of some table

It's a temporary GUID which ServiceNow generates and links it to sc_cart_item table during catalog form submission

More detailed discussion here

Is there a way to get the cart item id in portal

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

17 REPLIES 17

Sulabh Garg
Mega Sage
Mega Sage

Hello Anish,

"Table sys id" field under sys_attachment table contains the sys_id of the record on which the attachment is stored.

It will not contain the sys_id of  tables sc_cat_item or sc_cart_item.

To check the record from sys_id, you can use SNUtil and search the record with sys_id like below and click enter.

find_real_file.png

 

Please Mark Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

You mean the SNUtils Chrome extension?

 

Regards,

Anish

Yes..

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

you can scan any table by just simply search the sys_id using SNUtil.

 

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg