cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

How do I get a list of all users and email addresses.

bob_zins
Helper

Is there a way to write a report where I can get a list of user names and email addresses.  

6 REPLIES 6

ulf_thorn222
Inactive

Observed Users in a traffic flow or configured users in the application?

A list of all users with access to DC RUM.  I need to send an email to all users informing them of a system outage. 

adam_piotrowicz
Dynatrace Pro
Dynatrace Pro

Bob,

I'm afraid the only way is to run:

select PRINCIPAL_NAME, PRIMARY_EMAIL_ADDRESS from SECURITY_PRINCIPAL WHERE PRIMARY_EMAIL_ADDRESS IS NOT null

query against CSS DB.

Feel free to add such ENH on our forum.

Thanks Adam, can you please remind me how to launch the SQL Query tool. 

bob_zins
Helper

Adam, I just used SQL Server Mgt Stuido directly on the DB to run the query, but I only received back the local users, (36 of 360 users) none of the LDAP users were returned.  I have been using DC RUM Prior to the creation of CSS, so the user list is also available in the CAS.  Is there a table in the CAS DB that I can query to get my results.  

It would be:

select * from wslastused

but it's going to give you only user names for compatibility purposes.

Right, the CSS query returns only local users. For LDAP users you should rather use:

select PRINCIPAL_NAME, PRIMARY_EMAIL_ADDRESS from SECURITY_PRINCIPAL

but it will still not get the e-mails that are retrieved dynamically.

 

However Development helped us to find out ... CSV export in CSS 🙂

Go to CSS -> Users -> Export All

 

(smile)