Is there a table to check the number of downloads of files attached to cases, tasks and knowledge?

[Community Alums]

Is there a table to check the number of downloads of files attached to cases, tasks and knowledge?

[Tony Chatfield1 · Accepted solution]

Hi, I don't believe that there is a table dedicated to recording attachment acces,s but you can see an 'attachment.read' record in sysevent log every time an attachment is accessed\downloaded.

'sysevent' is a rotated table and so about 7 days worth of data are accessible via the table and it's rotations,
so depending on your use case\business requirements;
If you wanted to utilize the data for reporting then you would need to consider consuming the attachment.read sysevents to create entries\records in a custom table for reporting  or you might be able to create metric entries(metric _instances) to deliver some simple reporting functionality.
- You should be able to consume these events with a script action. 

[MartinKirwan]

@Tony Chatfield1 

Is there a way to differeniate between a downloaded attachment and one viewed using the 'Document Viewer'?
When I check the 'attachment.read' on the events table a record is created when I view or download.

Sorry for highjacking the thread 🙂