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

sieusaopolo15 · 3 weeks ago

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 · 3 weeks ago

@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! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

sieusaopolo15 · 3 weeks ago

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