2 Replies Latest reply on May 7, 2010 6:28 AM by Joy Garon

    How to print or export list of users in group?

    Tim Turpin
    Tim Turpin May 6, 2010 1:15 PM

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

      • 1076 Views
      • Categories: Data Management, Enterprise PDM
      • Tags:
        • Re: How to print or export list of users in group?
          Michael Dekoning
          Michael Dekoning May 6, 2010 3:44 PM (in response to Tim Turpin)

          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

          • Re: How to print or export list of users in group?
            Joy Garon
            Joy Garon Employee May 7, 2010 6:28 AM (in response to Tim Turpin)

            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