7 Replies Latest reply on Oct 24, 2013 7:16 AM by Petri Rautiainen

Export PDM User List?

Sally Hoo Jan 11, 2013 7:24 PM

Is there a way to export the user list from the administration tool so that it can be copied over to a Word or Excel document easily?

Re: Export PDM User List?

Ravi Teja Jan 12, 2013 6:24 AM (in response to Sally Hoo)
I dont think there is any option in user interface to Export the list of users from a vault.

You can use the attached report to accomplish this from EPDM report generator.

Regards
Ravi T

Forum.crp.zip 313 bytes
Like Show 0 Likes(0)

Actions
Re: Export PDM User List?

Michael Dekoning Jan 14, 2013 11:10 AM (in response to Sally Hoo)

Another option is to run the Show Users search for logged in and non-logged in users and export the result.
Like Show 1 Likes(1)

Actions
Re: Export PDM User List?

Sally Hoo Jan 14, 2013 11:21 AM (in response to Sally Hoo)

Thanks to both of you. Both ways work fine.
Like Show 0 Likes(0)

Actions
Re: Export PDM User List?

Petri Rautiainen Sep 25, 2013 9:03 AM (in response to Sally Hoo)

The .crp Ravi provided works fine for one vault at the time. Thanks for that.

Does anyone have a working .crp for listing all users in all/several vaults? We have several active vaults and it would be nice to list all users from all the vaults in one table...

Thanks!
Like Show 0 Likes(0)

Actions
- Re: Export PDM User List?
  
  Ravi Teja Sep 26, 2013 1:17 AM (in response to Petri Rautiainen)
  
  Petri,
  How many Active Vaults Do you have ?
  
  Regards
  Ravi T
  
  Like Show 0 Likes(0)
  
  Actions
- Re: Export PDM User List?
  
  Ravi Teja Sep 26, 2013 1:45 AM (in response to Petri Rautiainen)
  
  Petri,
  Find the Attached crp File .Open it in Text editor. and Replace Vault_1,Vault_2 with your Database Names.
  
  *_I have not tested it.I believe a vaults Report Generator is Not Limited to Using only its Database.
  
  Regards
  Ravi T
  
  Forum.crp.zip 349 bytes
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: Export PDM User List?
    
    Petri Rautiainen Oct 24, 2013 7:16 AM (in response to Ravi Teja)
    
    Thanks Ravi,
    
    I did a small modification to the .crp you sent and now it suits my needs perfectly:
    
    Instead of:
    Select 'vault_1' AS Vaultname ,Username from
    vault_1.dbo.Users
    
    I used the following
    Select 'vault_1' AS Vaultname ,* from
    vault_1.dbo.Users
    
    This way I get ALL the information of ALL users in ALL our vaults ready for exports as .csv file!
    
    So, thanks again for pointing me to the right direction!
    
    Like Show 0 Likes(0)
    
    Actions

Go to original post