1 Reply Latest reply on Sep 27, 2017 1:02 PM by Moe Hassan

    How to Purge ePO events in the DB

    anonn

      How do I  Purge ePO events in the DB, I have tried the below statements and they still do not work, please assist

       

      SET rowcount 10000

       

       

      DELETE FROM epoEvents

       

       

      WHERE detectedutc < '2015-06-01'

       

       

      WHILE @@rowcount > 0

       

       

      BEGIN

       

       

      DELETE FROM epoEvents

       

       

      WHERE detectedutc < '2015-06-01'

       

       

      END

       

       

      SET rowcount 0

       

       

      GO

       

       

      Delete from OrionAuditLog where StartTime  < (GetDate() - 90)