Attachment/Document retention time

[azsnow]

Hello SNOW community,

I would like to know the retention period for attachments added to a form or perhaps where to find it. Note: I have created a scoped app with a table extending Task. In case, this affects retention time.

I did some searching but most of it was tied to HR application.

Thank you!

[Raj_Esh]

Hello,

Attachments are stored in sys_attachment table and metadata in sys_attachment_doc

Please refer:

Attachments in ServiceNow

Administering attachments

Hope this helps.

Thanks,

Raj

[Hitoshi Ozawa]

AFAIK, attachments should be retained without a set period.

There are 2 Scheduled Jobs to clean attachments:

1. Cleanup Attachment Scan History - clean attachments that has been marked to be infected with virus
2. Remove Orphaned Attachments - remove attachments without form

Scheduled Jobs can be accessed from "System Definition" > "Scheduled Jobs"

[Hitoshi Ozawa]

Attachments can be deleted after a certain amount of time by creating a Scheduled Job.

Haven't tested but something like below in the scheduled job script.

var tableName = 'incident';
var grInc = new GlideRecord(tableName);
grInc.addEncodedQuery("sys_created_on<javascript:gs.beginningOfLastYear()");
grInc.query();
while(grInc .next()) {
  var attachment = new GlideSysAttachment();
  var agr = attachment.getAttachments(tableName, grInc.sys_id);
  while (agr.next()) {
    gs.info(agr.sys_id + " filename:" + agr.getValue('file_name'));
    attachment.deleteAttachment(agr.sys_id);
  }
}