How to link two archive rules?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-09-2019 06:48 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-24-2020 01:32 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-24-2020 02:20 PM
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.
-----------------------------------------------------
----------------------------------------------------------