- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 06:22 AM
Discovery Log (discovery_log) table is extended from Log Entry (syslog) table.
For syslog table there is a Table Rotation is set by default. That works for discovery_log table as well.
My question is, is it possible to set the Table Rotation different for discovery_log, then syslog?
(Currently there is nothing for discovery_log in sys_table_rotation table. But if I would add any different settings [like higher number for Rotations], than syslog, would it work?)
Why I am asking: I need to keep the Discovery Log table for longer period, that Log Entry, without adding too much to our database footprint.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2024 12:17 AM
Response from ServiceNOW Support:
"Unfortunately, and as you mentioned 'Discovery Log' (discovery_log) table is an extension of 'Transaction Log Entry' (syslog), and the only way to modify the rotation time for 'discovery_log' is modifying directly the 'syslog'; doing this, you will impact all the extended tables of syslog; and this is not recommended at all."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2024 12:17 AM
Response from ServiceNOW Support:
"Unfortunately, and as you mentioned 'Discovery Log' (discovery_log) table is an extension of 'Transaction Log Entry' (syslog), and the only way to modify the rotation time for 'discovery_log' is modifying directly the 'syslog'; doing this, you will impact all the extended tables of syslog; and this is not recommended at all."