Exporting all tickets with work notes to csv

[Ben91]

I'm looking to do a list csv export of all incident tickets. There doesn't appear to be way to include work notes and comments. We have a production instance which is retiring at the end of the month, we need to export all incidents tickets for future reference.

PDF detailed portrait isn't really an option as we have over 60,000 tickets to export.

Any help would be greatly appreciated.

Ben

[Ankur Bawiskar]

Hi,

Are you saying the production instance would be decommissioned. I believe you would require to go to sys_journal_field and apply condition as Name=incident

sys_journal_field this table holds the value of journal fields and for that table

So all journal fields for incident table you can export

You can use export set functionality for this; it can handle large exports

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ben91]

Thanks Ankur, I've exported all incident records and Journal fields for the incident table. I can now match these using sys id's.

Thanks again for your help.

Ben

[Ankur Bawiskar · Accepted solution]

Hi Ben,

Nice. Did you accidentally mark your answer as ✅ correct?

Regards

Ankur