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