AnsweredAssumed Answered

Search for a way to delete open incidents

Question asked by ahd on May 4, 2018
Latest reply on May 8, 2018 by ahd

Hi all,


we have a development environment that currently contains 180000 open tickets.

We are running CA SDM 17.1.
Therefore, the MSSQL database is currently over 10GB in size. I am looking for a way to archive or delete these tickets from the database - we do not need these tickets.
I found the following DocOps link, but I think it only works for closed incidents.


How to Archive and Purge Historical Data - CA Service Management - 17.1 - CA Technologies Documentation 

I can't touch and close each ticket manually.
Is it possible to delete the tickets from the table at database level? But there I will probably get problems with table references?


Alternatively, it is possible to mark an incident as closed at database level and then work with the regular archiving process.
Perhaps there are such possibilities.


Kind regards,