The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

would like a report with the members of each workgroup

Highlighted
Christina Mulch
Acclaimed Contributor

would like a report with the members of each workgroup

I am trying to get a report with workgroups and their members. I tried the workgroup explorer view and the file/print preview then the publish tab and save as HTML doc. All the HTML doc had was the workgroup names not the members of each workgroup
Thanks,
Christina
2 REPLIES
Tulio Quinones
Frequent Visitor

Re: 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


I can provide asp or jsp code if needed
Christina Mulch
Acclaimed Contributor

Re: would like a report with the members of each workgroup

Thanks for the information. Could you send the asp and jsp code?
Thanks,
Christina
//Add this to "OnDomLoad" event