How can I see variables in archived Service Catalog Request Item record?

[Darshil1]

I am trying to archive Service catalog request item record (sc_request_item). I am able to see variable in service catalog request item table (sc_request_item). But after archiving records I am not able to see variables in archived table records (ar_sc_request_item). Is there any solution regarding this problem? Any alternate way to view variable in archive request item?

[Brandon Barret1]

 I would read over this: Archiving Data - ServiceNow Wiki , it is a few years old, but may still be helpful. 

 As far as I know, archiving removes the pointers and other references to the variable, but not the original variable itself. I think you can still access those in the Service Catalog. If you know which Request Item Record has the variable you need to see, you can restore it and access the variable. See: https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/database-rotation/...

Hope that helps.

[Darshil1]

Yes I can access the variable after restoring. But after restoring we cannot archive that record.

[Faizel]

Archive variables
Current Archive Engine doesn't display variable information with archived requested items. With sc_request table you can archive sc_req_item table but not the variables table. You won't be able to see variable information on archived items. You will be able to see variable information if you restore the archived record. The items under 'Variables' section for archived RITM are not displayed, is by design. This is because UI Formatter works only for sc_req_item table, and not the ar_ tables.