After a mail loop I have more than 10k tickets from postmaster@domain.xx.

I would like to to be able to delete them in a easy way, and not use GUI to delete 150 tickets at the time.


Answer Summary:
1 Comment   [ - ] Hide Comment


  • The SQL database is read access only. You may be able to talk support into doing it for you but you will not be able to do it that way.
Please log in to comment

Answer this question or Comment on this question for clarity



I had this same issue and handled it with a ticket rule. First you need to find the USERID for the postmaster@domain.xx account (KACE should have created a user for that email address) and you'll need to place it in the queries below where I have <userid for postmaster@domain.xx>.

Use the rule wizard to create a blank rule (just leave the defaults for the wizard). Delete the contents of the select query and change it to the following:

DELETE FROM HD_TICKET_CHANGE WHERE USER_ID = <userid for postmaster@domain.xx>

So if your userid is 1235 the query would be


Clear the other checkboxes for the rule, save it and run it.

That statement will clear the ticket comments from postmaster. To delete tickets with postmaster as the submitter:

DELETE FROM HD_TICKET WHERE OWNER_ID = <userid for postmaster@domain.xx>

Answered 05/12/2014 by: chucksteel
Red Belt

Please log in to comment