Logs Retention Period

[Mayur Patil2]

Hello Developers,

I am currently working on the logs retention period. Specifically, I wish to update the retention period to one year.

The logs I intend to update are: syslog, syslog_transaction, import_log, and sys_import_set_run. By default, there are table rotation records for syslog and syslog_transaction, but not for the other two tables.

Therefore, I need to verify the current retention period for import_log and sys_import_set_run, and determine how to modify it to one year.

From my understanding, this change will impact the database. However, I would appreciate your insights regarding any additional impacts or considerations.

Thank you for your assistance.

Mayur Patil

[Bhuvan]

@Mayur Patil2 

Table rotation for out of box tables are designed to optimize the performance and is not recommended to change the retention period for logs and import sets. If you change to longer retention, you will surely run into issues as data records will grow into millions and would severely impact the performance.

For example, import sets are cleaned up every 7 days.

If this is a must have, look at data replication options

https://store.servicenow.com/store/app/e019a76e1be06a50a85b16db234bcbef

If this helped to answer your query, please mark it as helpful & accept the solution.

Thanks,

Bhuvan

[Mayur Patil2]

Thank you, Bhuvan. Your expertise has been helpful

[Bhuvan]

@Mayur Patil2 

Thanks for marking the post as helpful.

If it helped to answer your query, please accept the solution. As per community guidelines, you can accept more than one solution and if someone provides you with insightful information, you can mark their post as solution as well.

Thanks,

Bhuvan

[Bhuvan]

@Mayur Patil2 

Can you please check this thread and accept the solution so that it can benefit other community members in future.

Thanks,

Bhuvan