Purge Audit logs on daily basis from an older date

[MH_9911882]

1. Describe your environment: What is your industry? What is your role in your organization? Describe your stakeholders.
Windchill production environment. Manufacturing semiconductors. 

Windchill Consultant.

1. 
   2. What version of Windchill are you currently running?
   Windchill 12.0.2.3
   
   3. Describe the problem you are trying to solve. Please include detailed documentation such as screenshots, images or video.
2. The ask is to purge audit logs on daily basis irrespective of any time. This means that, if I wanted to purge audit logs starting from last year (2021) on daily basis, I should be able to schedule a job.
3. Another feature, that would really make like easy is to have a quick button to select options to retain logs for last 6months, 3 months from the current date and delete the rest recursively
   
   
   4. What is the use case for your organization?
4. The OOTB property wt.query.template.queryLimit=100000 has to be set in order to delete large number (of months together) of audit records from windchill UI. In order to do so, the above said property value should be changed to wt.query.template.queryLimit=-1 (-1 indicates unlimited records)
5. For the above changes to take effect, Windchill services needs to be restarted
6. But with the OOTB setting only a day's audit log can be purged. As the average audit record returned for a day is approximately 60000. And if we still attempt to delete even 2 days of audit logs, the purge will fails as the total number of records to be deleted will be 120,000 which is more than default value 100,000
7. As a counter measure, we intend to delete/purge logs on daily basis so that we don't have to change the OOTB settings and restart Windchill services every time.
8. there should be a feasibility to delete logs of last year or no matter whatever duration on daily basis. Currently the purge schedule job, does not provide this feature. 

5. What business value would your suggestion represent for your organization?

1. a lot of DB space can be freed with this purge scheduler.
2. Less human intervention
3. automated maintenance
   
   @apattanaik 

[olivierlp]

Thank you for your idea, @MH_9911882 and welcome to the Community. Based on the information you provided, we are acknowledging it as the Community management team. This is not a commitment from the Product team. Other users may comment and vote your idea up.

[uai]

yes it would really be helpful if you were able to schedule a job like delete everything older than....