How many days will data in table Transaction Log (syslog_transaction) be cleaned up ?

[sieusaopolo15]

I have created reports inside this table syslog_transaction and last month I can get data from range 16-09-2025 to 29-10-2025 which means 44 days and I expect it would be the same for this month which means my data range for this month will be 15-10-2025 to 27-11-2025 but data only existed at date range 25-10-2025 to 27-11-2025. Why is there a big different in data log in this table ? Is there any special configuration inside this table because it is listed as rotation table ?

[Ankur Bawiskar]

@sieusaopolo15 

yes table "syslog_transaction" is having table rotation

-> ServiceNow rotates this table weekly, with typically 8 rotations, resulting in a rolling retention window of about 8 weeks (56 days) at most

-> After 8 weeks, the oldest data is overwritten by new data as the rotation cycle continues

Preserve performance by halting excessive logging in syslog tables 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[sieusaopolo15]

Thanks @Ankur Bawiskar, it is a great information but I want to ask when will a rotation will turn offline ? It seems like when a rotation is offline I can't get it's data log

[Sarthak Kashyap]

Hi @sieusaopolo15 ,

You will get some information from below articles 

https://www.servicenow.com/community/servicenow-ai-platform-blog/keeping-your-instance-database-foot...

https://www.servicenow.com/community/developer-forum/logs-retention-period/m-p/3357912/page/2

https://www.servicenow.com/community/servicenow-ai-platform-forum/transaction-log-retention-period/m...

For your Offline issue 

https://www.servicenow.com/community/developer-forum/table-rotation-schedule/m-p/1411686

Please mark my answer correct and helpful if this works for you

Thanks and Regards,
Sarthak