Use this SQL query to delete the remediation tickets by Status and particular scans
DECLARE @ScanConfigID int
SET @ScanConfigID = #
FROM ticketsChanges tc
INNER JOIN tickets t ON tc.TicketID = t.TicketID
WHERE t.Status = 'Assigned' and t.ConfigurationID = @ScanConfigID
DELETE FROM tickets
WHERE Status = 'Assigned' and ConfigurationID = @ScanConfigID
Replace "#" in line three above (SET @ScanConfigID = #) with the desired Scan Configuration ID, which can be found in the ScanConfigurations table and desired status of the remediation tickets
As a rule, we don't recommend/support customers manipulating the DB in this way. Whenever possible we recommend using the UI to accomplish what they need.
So, before such a query is ever run against the DB - be sure to back it up.
Thanks for this .Unfortuanately I saw this a little late so I couldn't use it .However I will make note of it .In my case ,I wanted to remove all the tickets so I used another query to delete all the events prior to a specified date .It worked for me .However I have another situation .Maybe you can help me with that .I have integrate My foundstone with ePO 4 and it imported all the data .Later I remove a lot of scans from foundstone which reduced the data about vulnerabilities detected but ePO still shows the Old data .how can I configure ePO to purge the Old imported data and import it again to reflect the latest changes .I can run queries on ePO but I dont know on which table .