Deleting tickets...?

[ambarnes]

Is it possible to actually delete incident/call tickets after they reach a certain age? I have not yet seen this mentioned in SC's admin manuals.

[tommy]

Yes there are several ways to do this both manually and automatically.

Check our purge/archive in the manuals.

I do it manually through the database manager.

[fjespersen]

Be very carefully with deleting Incident tickets - If there is an Alert record left in the schedule file, your system could go down, due to a loop in the alert routine.

This should not be possible when the ticket is closed, so ensure you only delete closed tickets.

Also check out datamap.

[tommy]

What do the datamap do? A lot of people are talking about that.

I have always purged closed tickets via database manager.


Good point about the schedule records. We have had our sun test environment loop and go down on that. It took a couple of hours to cleanup :evil:

[fjespersen]

Datamap enables you to delete/archive records in related tables.

Look at the datamap for the probsummary table, it includes problem and screlation tables, meaning that if you delete probsummary records using datamap, all related problem pages and screlation records will be removed. You should add the schedule record with a map to field: pm.number to the datamap.