The CreatorCon Call for Content is officially open! Get started here.

How to link two archive rules?

Darshil1
Tera Contributor

I am trying to archive catalog request record. Along with requests I need to archive request items(RITM) and tasks. I also need to archive catalog variables. For that I need to archive Options [ sc_item_option ] and Variable Ownership [ sc_item_option_mtom ] . I am trying to archive records which are 2.5 years old. Number of requests are pretty huge. Each request have some variables. Archive Rules executes on batches like 1000 per run. If one request is archived then all the variables which are associated with this request also need to be archive. I tried to write independent archive rules for table but not able to achieve this. Do you guys have any idea regarding this problem?

11 REPLIES 11

 By the way i configured in the above posted image it archived all other tables after some time except the sc_item_option. Any idea how to include the sc_item_option table too?

 

FYI there are two images. 

The table name which i selected for Variables doesnt look like the right table. Not sure what table name to select for sc_item_option from the table name list. Ideally Servicenow should also include the real table name instead they are giving just the General name of the table.

-----------------------------------------------------

----------------------------------------------------------