Service Desk Practitioners Forum
cancel

Persons in Multiple workgroups

SOLVED
Go to solution
Highlighted
Peter J Gray
Respected Contributor.

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
Acclaimed 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
Acclaimed 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