Delete Discovery Logs

shubhamverm6594
Tera Expert

Hi All,

 

I want to delete discovery logs which created 90 days ago or later.

Is there any system property to delete records automatically or I need to create scheduled job, Can anyone help me on this one?

Thanks,

Shubham Verma

1 ACCEPTED SOLUTION

shubhamverm6594
Tera Expert

Hi All,

 

I found the solution after analyzing the things.
We have an OOTB table name is "sys_auto_flush" as seen in below.

Do the filter on table level and search the records.

We simply set active true and update the days (Converted time from days to second) then save the record

 

shubhamverm6594_1-1723453921054.png

 

 

 

View solution in original post

4 REPLIES 4

Sohail Khilji
Kilo Patron
Kilo Patron

Hi @shubhamverm6594,

 

Discovery Logs table is  extended by  syslog table , so whatever rotation is currently setup for syslog applies to Discovery Logs as well.

 

You can check for log rotation to manage the discovery log table. I hope this helps...


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

Hi @Sohail Khilji ,

 

Thanks for your response.

How I can check for log rotation to manage the discovery log table. please guide me on this.

go to > navigator > system defination > Table rotations

 

Here you have all the tables rotation setup. Kindly mark the answer correct if it helps...


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

shubhamverm6594
Tera Expert

Hi All,

 

I found the solution after analyzing the things.
We have an OOTB table name is "sys_auto_flush" as seen in below.

Do the filter on table level and search the records.

We simply set active true and update the days (Converted time from days to second) then save the record

 

shubhamverm6594_1-1723453921054.png