ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to determine how many incidents are waiting to be deleted


Article ID: 159879


Updated On:


Data Loss Prevention Enforce


I know incidents aren't actually deleted when I deleted them, they are just marked for deletion.

How can I determine how many incidents are "deleted"?


The incidents that are "deleted" and will be purged can be counted with the following query run as the protect user.


For more information on the deletion process, see TECH219858


Login to sqlplus;

sqlplus /nolog

conn protect/[email protected]

Select count (*) from Incident where IsDeleted = 1;