Is it possible to report on all records updated by a particular user?

Brian Bouchard
Mega Sage

I've been asked about creating a report showing a count and/or list of all records updated by a particular user id in a particular period of time. So for instance, "How many records did Jeremiah Peabody update in the last 12 months?"

Is this level of historical information captured somewhere that can be reported or scripted against?

5 REPLIES 5

Adam Stout
ServiceNow Employee
ServiceNow Employee

This information lives in sys_audit, but this is blocked from reporting since this could cause performance issues. 

What is the value of this report? Is it a one time issue?  What do you consider a meaningful update?  Are you tracking just task-based updates?  Perhaps a scripted metric could do it, but if you only need an occasional audit, I would still to a special report on sys_audit.  If this is more common, then a larger solution may be needed.