Touched incidents by particular assignment group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi Everyone,
I have a requirement to generate a report that shows how many incidents were handled by the Database group, how many were closed by them, and how many were transferred to other groups. I attempted to create this report using the databaseview table, referencing the sys_user_group, sys_audit, incident, and sys_user tables. However, the report is not producing the expected results. Could you please help me understand how to resolve this issue?
Thanks,
Abhishek KM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi,
There are a few that come out-of-the-box(OOTB) that can be used. If you look under Metrics > Definitions. You will find some created for Incident like "Assigned to Duration", "Incident State Duration", "Assignment Group", etc. that can be used. Some of them are scripted and some are triggered base upon a field change. It's possible these can help or maybe be combined with your DB view to get the data you want.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
check this article
Generate Report for Incidents handled or touched by your team even after reassignment
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader