Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Need report - users who have worked on incidents, problem, change requests in last 60 days

Suggy
Giga Sage

I need to build a report:

List of Users who have worked on incidents in last 60 days (if a user has touched the record, then consider that user has worked) 

Ex - added comment, modified any field etc.

 

PS - I know that creating report on sys_audit is not recommended. Then what is the solution?

1 REPLY 1

Tanushree Maiti
Kilo Patron

Refer this :

KB0954528 How to create time worked report for incident, catalog tasks and change tasks 

 

Instructions


A. You can create a report on the time_worked table and include the necessary filters for each of incidents, catalog tasks and change tasks.
> Table: time_worked
> Filter: All>Task Catalog [Catalog Task] Active = true .or. Task Change request [Change Task] Active = true .or. Task Incident state [Incident] is not empty
> Group by User
> Configure Total sums for calculations (Right click the header for 'time worked' > click configure > list calculations > check total value)

 


B. This would be the columns selected in the table -
> Under the configure tab, in creating a report: click choose columns
> There should be an option to deselect "time worked in seconds" and add time worked (which will automatically be in hours)

 

[ Report ] People worked on incident 

 

 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin: