Attachment Archiving

[jpro]

I am missing something when it comes to the Archiving Plug-in module. It does not look like it will archive attachments along with the incidents. I cannot archive incidents without the evidence that could be contained within the attachments. I can get the sys_attachment information that contains the name and size of the attached document but, no document. sys_attachment_doc is not even listed as available to archive.

Can anyone point me in the correct direction. Thanks.

[john_roberts]

Attachments should be re-linked to the archived record automatically. There's no need to archive this as a related record. If you archive an incident with attachments you will notice that the sys_attachment record is updated to link to the ar_incident table instead of incident. The attachments will now be visible from the archived record.

[jpro]

One of the purposes for archiving records is to move them from the main database or table to assist in overall performance and storage options. I am consfused since the sys_attachment_doc table has to be one of the larger tables since it contains the attachments. Why would you not archive this table, yet archive its meta data table sys_attachment? This causes concerns as there is no feasible method to move a complete incident, request, change, etc. into a permanent archive and purge from the production database.

[john_roberts]

The archiving plugin only archives by moving rows from the primary table to a new archive table. It doesn't remove anything from the database. It's primary purpose is to improve reporting and query times on very large table where you really don't need to report on every record in history. Very large environments experiencing database related limitations or performance problems can talk to support to see if their are better options for them.

[scotthal]

Why is the attachment table listed as the example in the wiki, if you can't actually archive attachments? I feel like I'm missing something.

https://wiki.servicenow.com/index.php?title=Archiving_Data#Viewing_Archived_Data