Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Persons in Multiple workgroups

SOLVED
Go to solution
Highlighted
Peter J Gray
Regular Collector

Persons in Multiple workgroups

Hi,

Can you advise if it is possible to derive a list of all workgroups a Person is a member of in Openview. Currently I can't find a way to view what groups one person is a member of.

Any suggestions on this matter would be appreciated.

Thanks,

Peter
2 REPLIES
Mike Bush
Honored Contributor

Re: Persons in Multiple workgroups

Your PERSON form can be extended to have a "Workgroups" tab containing the set of Workgroups this person belongs to.
Mark O'Loughlin
Honored Contributor
Solution

Re: Persons in Multiple workgroups

Hi Peter,

you could get a DBA to run this:

Would like a report with the members of each workgroup

Use a sql query against the Service Desk to view v_member to list all of the members and workgroups.

SELECT workgroup_name, person_name
FROM v_member
ORDER BY workgroup_name
//Add this to "OnDomLoad" event