Service Desk Practitioners Forum
cancel

list of all persons v/s workgroups

Highlighted
Mr.NiceGuy
Valued Contributor.

list of all persons v/s workgroups

Hi,

OVSD 5.10 on HP-UX, Oracle

Can some one tell me how to get a report/list of all persons in SD and corresponding workgroups ? I'm able to get this in an explorer view but not in table view. Can some one shed some light on it ?

A sql query, if someone has it already, also will do.

regards,
1 REPLY
Mr.NiceGuy
Valued Contributor.

Re: list of all persons v/s workgroups

The following view in Oracle db has this info:

V_person2workgroup

Thanks.

regards,