How can I print or export list of users in a group? In the EPDM Administrator I have groups set up. Is it possible to print the list of individuals in a particular group or to export that list and view in some other program?
Trying to cross reference all groups and would like lists to visually see all users in group at a glance.
Using EPDM 2008.
Thanks, Tim...
Hi Tim -
As Mike pointed out, you can use an Enterprise Report or, if you're comfortable with SQL Server Management Studio, you can just run a T-SQL query.
Use EnterprisePDM; --- replace EnterprisePDM with your vault name DECLARE @group nvarchar(15); SET @group = 'Engineering' --- replace 'Engineering' with group name or use '%' for all groups SELECT U.Username, G.Groupname FROM GroupMembers M INNER JOIN Groups G ON M.GroupID = G.GroupID INNER JOIN Users U ON M.UserID = U.UserID WHERE G.Groupname LIKE @group AND Enabled = 1 Best Regards, Joy
There is a report called "User details of selected group(s)" that you can run from the Report Generator. You can print or save the results to a csv file.
Mike
EPDM 2010 SP2