How to delete certain archived data?

[ariya9]

Due to a special request, I need to archive around 300 incident tickets and permanently delete them from the archive table. (They just don't want the data to exist in the system at all).

How can I delete only these 300 tickets from the archive table, without deleting the other existing data in the table?

I couldn't find any relevant information from wiki, and couldn't find any options to delete the archived data. (Only found option to restore).

Can anyone please advise on this?

Thanks & regards.

[sergiu_panaite]

Are the records already archived?

If yes, then you can't delete them, the UI action for Delete is disabled for archived records. We normally don't delete archived records. That means you also can't use the GlideRecord deleteRecord or deleteMultiple functions.

One way of deleting them, if they are archived, is to restore them first then you have the UI action for Delete.

Regards,

Sergiu

[ariya9]

Hi Sergiu,

Thank you for your reply. Yes the records have been archived. We did not delete the records straight away from Incident table because there are some concerns it might have an impact to the existing relations with other records.

I assume that we can delete all data from ar_incident table by going to the table and click on the option "Delete All Records". But what if we only want to delete only certain tickets from the ar_incident table. Is that possible? Or if we can't delete the tickets, is there a way we can remove certain parts of the tickets? For example deleting the Activities in the archived ticket?

Thanks & regards,

Bariyah

[sergiu_panaite]

Hi Bariyah,

Even if you see the UI action "Delete All Records" in Tables it doesn't work for archived tables. There is no possibility for you to delete them via UI.

If I use that UI action on my test instance (I have around 30K archived incidents) I get the following message when deleting:

"Table Archive Incident is already empty. No record(s) deleted."

so actually nothing gets deleted.

Regards,

Sergiu

[ariya9]

Hi Sergiu,

Thanks for your reply. So in the future when there will be a huge number of records being archived, how do we delete/purge them?

Is there any policy on SNC side where the archived records will be purged after certain period? Or do we need to raise a request to purge the archived data?

Thanks & regards,

Bariyah