PDM Pro Crp file: User export

[Ry-guy]

I'm sure we have PDM Pro users our there. I'm looking for simple .crp file to give me a list of users and email address. Anyone have one they can share?
Many thanks in advance.

[jcapriotti]

Code: Select all

@[Userlist]
§Name [User List]

§Company [TKE]

§Description
[This query will list all active users in the system]

§Version [1.1]

§Arguments
[
]

§Sql
[
SELECT USR.Username as 'Login name'
      ,USR.FullName as 'Full name'
      ,USR.Initials as 'Initials'
	  ,USR.Email as 'Email'
  FROM Users USR
  where USR.Enabled=1 and (USR.Username is not null and USR.Username != 'admin' and USR.Username not like '$%')
  order by USR.Username
]


/*******************                        ********************/