We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

sieusaopolo15
Giga Sage

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 ?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron

@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 

AnkurBawiskar_0-1764255797755.png

 

💡 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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron

@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 

AnkurBawiskar_0-1764255797755.png

 

💡 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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

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

 

sieusaopolo15_0-1764256661959.png

 

@sieusaopolo15 

offline true means table is inactive and cannot be queried from UI

💡 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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader