Reports that show a users activity
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2011 07:05 AM
Is there a report from within SN that I can run that will show the activity of a user.
I need information such as do the open incident, change, or request... Do they close or resolve tickets? Not just if they have logged in.
Thoughts?
Also, I have crystal v10 so I can run any report. Just cant find the right criteria if it exists.
Thank you in advance,
Shirley
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2011 07:48 AM
I would run reports off of the Event [sysevent] table.
It will store information when a user causes an event to fire. The Created By is the user that caused the event to occur. You may need/want to build custom events to detect reportable events that are not provided with the base build.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2011 08:15 AM
I don't seem to be able to see that table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2011 08:20 AM
http://wiki.service-now.com/index.php?title=Reporting_on_System_Tables
System Properties > UI Properties
The property description is "List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2011 09:18 AM
I read the wiki article and I do not have that entry in our system properties in any of our instances. The only one close on system tables mentions the addtion of audit to certain tables.
I was able to access the table through filter text.
Any other ideas? I think I am going to try Crystal reports.
