How to create a report that includes all ServiceNow tickets, incident, problem change, request, case, etc., that were updated (ever touched) by a user/assignee?

Scott I
Mega Contributor

Can I create a report that includes all ServiceNow tickets, incident, problem change, request, case, etc., that were updated (ever touched) by a user/assignee?

1 ACCEPTED SOLUTION

Scott I
Mega Contributor

Thanks Sachin. I will try this Monday...

View solution in original post

5 REPLIES 5

Robert K
Tera Contributor

Scott,

The parent table would be Task as Sachin mentions.  

Reporting off "Updated By" will only display last user who has updated the record.  Think of Updated By as "Last updated By". 

However, if you are looking for historic rather than current values I think you will need a database view.

To report off previous updates by a user you will need to bring in metric instances for the fields you wish to report off of using a database view.  An example for Incident might be "incident metric" table to see how to report off a historic value ("metric instance")

https://community.servicenow.com/community?id=community_question&sys_id=1a824721dbd8dbc01dcaf3231f96191c&view_source=searchResult