Need report - users who have worked on incidents, problem, change requests in last 60 days
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
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
