Deleting a large number of incidents due to an email loop in email listener.

Version 1

    Details

    An email loop generated 6500+ incidents in Heat. Is there an easy way to bulk delete these other than highlighting and hitting delete in the Incident list?


    Resolution

    You can use a delete quick action and highlight the incident via holding ctrl button and clicking on each with the mouse. For 6500+ incidents, this gets to be tedious. I would recommend a backend sql script. The created incidents should be in a incidentnumber range. You may want to verify that no legit incident number get delete but i would recommend the following sql script for example. This  example deletes incident number between and including 10394 through 10401.


    DELETE FROM [dbo].[Incident]
          WHERE IncidentNumber between 10394 and 10401