ePolicy Orchestrator Db table orionscheduletasklog

[ecostelli]

I checked in my epo db that table with large space used: OrionSchedulerTaskLogDetail 60427819 6 47951752 KB OrionSchedulerTaskLog 13265306 11 3134000 KB OrionAuditLog 4249677 14 908592 KB SCOR_BINARY_REPUTATION 1234932 28 828232 KB I tried to delete the row with task purge but the task still run for many time and crash. I tried with query but i found this error: he DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_OrionSchedulerTaskLog_OrionSchedulerTaskLog". The conflict occurred in database "ePO_GTTSRV102", table "dbo.OrionSchedulerTaskLog", column 'ParentId'. The statement has been terminated. Could you send me the query to clear this tables ? OrionSchedulerTaskLog and OrionSchedulerTaskLogDetail Thanks Best regards Thanks

[rackroyd]

Please log a McAfee support case so this can be assessed in more detail. As you've spotted there are constraints that will prevent direct deletion. This is because there are dependencies on other tables that would be affected adversely by such action, so it must be done with care.