- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2021 09:24 AM
Hello Communnity, I was asked if I can create a report to show all tickets that are created by ServiceDesk. We have over 75 members as part of Service Desk and typing each name in created by will take time and as people are removed or added to that group, someone would have to maintain the filter.
Is there a way to create the report using created by has a role or created by is member of a group?
Thank you for your help in advance!
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2021 09:44 AM
Hi,
You can create a scripted filter that returns the members of that group. I answered a question like this in this thread:
There is also a second way, using database views.
You can join the sys_user_grmember table to the task table on task.opened_by = sys_user_grmember.user. This database view will then contain a row for each combination of task and the groups that the opened user is a member of. Meaning if the person who opens a task is a member of 3 groups, there will be three rows for that task in the DB view.
Then filter to only show the rows where the sys_user_grmember.group is "Servicedesk". This will then return only the rows where the task was opened by a person who is a member of the servicedesk group, one row per task since a person cannot be a member of the same group twice.
Hope this helps, if so I would appreciate if you marked my reply as correct. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2021 09:44 AM
Hi,
You can create a scripted filter that returns the members of that group. I answered a question like this in this thread:
There is also a second way, using database views.
You can join the sys_user_grmember table to the task table on task.opened_by = sys_user_grmember.user. This database view will then contain a row for each combination of task and the groups that the opened user is a member of. Meaning if the person who opens a task is a member of 3 groups, there will be three rows for that task in the DB view.
Then filter to only show the rows where the sys_user_grmember.group is "Servicedesk". This will then return only the rows where the task was opened by a person who is a member of the servicedesk group, one row per task since a person cannot be a member of the same group twice.
Hope this helps, if so I would appreciate if you marked my reply as correct. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2022 04:41 AM
Hi Nik,
Could you please share a detail step by step for the 2nd way?
Really appreciate if you can assist on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 07:48 AM
Hi Nik,
I am creating a similar report and am unable to utilize the link provided by you. Seems, it is marked as Archived. Could you please share the solution here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 12:11 PM
Take a look at this one, it might help you
