How do I get a list of all users and email addresses.
Is there a way to write a report where I can get a list of user names and email addresses.
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.
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.
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
