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.
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.