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 

Did you get a chance to review this ?

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

Thanks,

Bhuvan

[Chaitanya ILCR]

Hi @Mayur Patil2 ,

import_log table is an extension of syslog table, so table rotation would clean the import_log table too

for sys_import_set_run  OOB there is a scheduled job which deletes the data older than 7 days OOB you can update it as per you requirement

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Mayur Patil2]

Thank you, Chaitanya. I had the same understanding. I have check both the things you mention. 

[Mayur Patil2]

Hi @Chaitanya ILCR ,

Thank you for your input it really help me. Below are my understanding

syslog(parent) -> import_log(child):- table rotation(syslog)

Scheduled Job: Import Set Deleter and Script Include: ImportSetCleaner: Helps to clean import set(sys_import_set) table and sys_import_set_run

syslog_transaction_log :- Table rotation(syslog_transaction_log)

sys_user_login_history:- ?

Now I want to know how sys_user_login_history records are getting deleted, in my Client environment last record created is showing 30days ago.

Please help me with is there is any table rotation or Schedule job is OOTB.

Thank you.

[Chaitanya ILCR]

Hi @Mayur Patil2 ,

OOTB there is a table cleaner set up on that table which delete the data older than 30 days

could you please mark my responses as helpful and accept them as solutions if in case they have helped you

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya