Changing Table Rotation settings for Discovery Log table

[JozsefB]

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.

[JozsefB · Accepted solution]

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."