Transaction log retention period

Tepp
Tera Expert

HI,

How long does the transaction log retention period?

 

Best regards,

1 ACCEPTED SOLUTION

Tony Chatfield1
Kilo Patron

Hi, logs are managed via table rotation, and syslog_transaction has 8 weekly rotations.
1 is pre committed to next week, meaning you can see normally see 6 full weeks of historical data + the current week todate via syslog_transaction.list

But
through the magic of table rotation you may also see an extra week if you navigate directly to the oldest rotation table – the one flagged as offline = true.

/nav_to.do?uri=sys_table_rotation.do?sys_id=bfa47be9dbb0230076ceb5ec34961924

https://hi.service-now.com/kb_view.do?sysparm_article=KB0721331

View solution in original post

1 REPLY 1

Tony Chatfield1
Kilo Patron

Hi, logs are managed via table rotation, and syslog_transaction has 8 weekly rotations.
1 is pre committed to next week, meaning you can see normally see 6 full weeks of historical data + the current week todate via syslog_transaction.list

But
through the magic of table rotation you may also see an extra week if you navigate directly to the oldest rotation table – the one flagged as offline = true.

/nav_to.do?uri=sys_table_rotation.do?sys_id=bfa47be9dbb0230076ceb5ec34961924

https://hi.service-now.com/kb_view.do?sysparm_article=KB0721331