I need to purge the events of a particular event, lets say 1095 which are lessthan 90 days on the SQL End. Do we have any query related to that ?
In our Database we are having a million records of 1092 and 1095 Events. So I tried searching for McAfee
KB's but I didn't found the exact query for purging these events.
Please help if anyone are having a solution.
Currently we are using ePO 5.3.3 version. There are 6million events for the event 1095 and 4million of 1092 events. So we need a query to purge those. which is stopping us from upgrading to 5.9.1. So please help with a Query to purge those events which are less than 90days. I even gone for the query on the SQL server to purge the events of which are less than 90days. But still the count for these(1095,1092) events the count didn't came low.