Reporting on Incident Opened by a Member of a Group?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-05-2009 05:05 PM
We have many members of each group and we want a report on all incidents opened by members of a particular group. The only way we are able to run the report is to filter:
"Opened by - is - Brian - OR Opened by - is - Craig - OR Opened by - is - Alex - OR and so on..."
Is there a way to filter "Opened by - is - a member of 'Service Desk'?"
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-05-2009 05:06 PM
I should have said...
Is there a way to filter "Opened by - is - a member of 'Group Name Here'?"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2009 04:08 PM
I'm not aware of any way to do this unless the group is associated directly with the user on the user record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2009 09:49 AM
Try using the Cost Center property/attribute. The Help Desk at our company has its own cost center. For example,
Table: incident [incident]
Group by: Employee number
Filter and Order:
Opened By.Cost Center is 33156
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-08-2009 04:20 AM
The difficulty with this is that Service-now does not restrict group memberships. i.e a user can be in more than one group. There is a way around this that I have implemented for a customer in the past.
1. Create a new field on the user table called u_primary_group. This will then need populating with their main group.
2. Create a new field on the incident table called u_opening_group.
3. Create an on insert business rule that has a single statement :
current.u_opening_group = current.opened_by.u_primary_group;
(if its possible to change the opened_by value in your system you might make it run on insert and update but with the condition:
current.opened_by.changes()
You will be able to report on all new records from the time the rule is activated (obviously historical records will not have this info). If you want to get this info for all records you make the business rule active on update with no condition. Then do a mass update of the incident table after populating the primary group.That will populate the opened_group field. Remember to set it back to on insert or on update with the condition.
Its a bit long winded - but as I said this is due to the fact the user to group relationship is many-to-many so you cant reference any single group for a particular user from reporting queries or other filters. Hope that makes sense.
Dave.