How to link two archive rules?

[Darshil1]

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?

[Boyan1]

Hello, 

You can use the Archive related records option in ServiceNow. Please check below link:

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/database-rotation/...

Actually you can archive related records on several levels.

1. Prepare archiving  rule for sc_request

2. Add related archive record rule for sc_req_item table

3. In Reference table rule, you add an archive rule that actually will process the related records to sc_req_item table

Let me know if you have any further questions.

Best regards,

Boyan

[Geoff_T]

Hi,

I have a question. I have an archive rule on the sc_req_item table. I can add related rules for:

Task (sc_task.request_item referencing sc_task table)

Approver (sysapproval_approver.sysapproval.mtom referencing sysapproval_approver table)

I don't however see any referencing option to capture related rules for:

Variable Ownership (sc_item_option_mtom)

Group Approvals (sysapproval_group)

Have you handled this - if so how?

Thanks

[Geoff_T]

Hi,

I have been able to archive sc_request records and also related sc_req_item, sc_task, sc_item_option_mtom records. I am having issues figuring out the best way to also archive the sc_item_option records however without creating a totally separate rule. Where you able to find a solution for the sc_item_option records?

Thanks

[Sebas Di Loreto]

Geoff, 

While on the Requested Item archive rule, go to the "archive related records" related list and click NEW. Then select action=archive and reference=request item... SUBMIT.

Now check the "archive related records" related list and you will see a new entry with reference="sc_item_option_mtom.request_item.mtom" and reference table="Variable Ownership [sc_item_option_mtom]".

Hope this helps.