Audit sys_attachment table

jk061
Kilo Explorer

Hi, is there way to turn-on audit on the sys_attachment table in particular track new attachments. I have enabled audit on this table as well as change system properties as mentioned in the following link, but in vain. However, I do get delete log in the audit table if an attachment is deleted.

Turning on Auditing (History) for a Table - ServiceNow Wiki

Appreciate any Help.

Thanks.

1 ACCEPTED SOLUTION

Hi Juzer, actually the url could be even simpler. You just need the sys_id of the record in the attachment table


/sys_attachment.do?sys_id=cf17426f31580200d898efb70c924169 // change the sys_id to what you need


Thanks,


Berny


View solution in original post

10 REPLIES 10

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Juzer,



You may find the below link helpful.


https://community.servicenow.com/people/MB/blog/2013/02/20/2484


Hi Pradeep,



I did came across the link that you mentioned in your reply. I would like to make it work via the audit table without using any business rule. Interestingly, it reports deletion, but not new attachments.



Thanks,


Juzer


Hi Juzer, I believe the reason why audit is not fully available for the attachment table is because of the size and so then performance implications that it could have in your ServiceNow instance. As a system table, some operations like auditing or reporting are restricted for our good.



It's not a bad idea to look into the business rule based solution of how to keep track of attachment changes within each associated record in the system.



Thanks,


Berny


Hi Berny,



Thanks for you reply. It is a bummer. Is there any alternate way to know if an attachment was made to say an asset, incident etc. record besides writing a business rule as Pradeep mentioned.



Thanks,


Juzer.