- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2014 04:10 AM
Hello dear ServiceNow Community,
Is it possible to generate reports on the TASK table to show groups or users that were involved in a record?
Meaning if our Network group was involved somewhere, the task-record should show in the report. Same goes for a users, if (s)he was involved in a task-record, it should show up in the report.
Thank you and
Kind Regards,
Michel
Solved! Go to Solution.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2014 01:34 AM
the only other way to do it on historic records would be to use sys_audit and focus on the elements of assigned_to and assignment_group
a query such as this would give you last 90 days:
The other way might be to use the method I talk about here and generate sys_history sets for your records then build a report on sys history for incidents, the difference is the values returned in there are much nicer than the sys_ids your going to get from sys_audit
Reporting on CI Changes - Using History Sets
One word of caution when dealing with either is if you've got a very large instance, this is going to take a while and could even cause some degradation whilst your transaction is hogging resources, so I would try to focus on specific dates, fields and do a fair bit of testing in sub-prod instances.
Hope some of that helps anyhow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2014 06:13 AM
I take it as granted... even though this is really RAW. I might consider to build an application around it once I have more time to spend.