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

list of all persons v/s workgroups

Highlighted
Mr.NiceGuy
Super Collector

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
Super Collector

Re: list of all persons v/s workgroups

The following view in Oracle db has this info:

V_person2workgroup

Thanks.

regards,
//Add this to "OnDomLoad" event