I have to create a security/access matrix for our Enterprise and there are 500+ users already entered into the CMC - what I’d like is to be able to get them into a report (in Excel preferably). Does anybody know how?
I’m a first-time poster and would appreciate any help!
Thanks,
Craig
craigglimm (BOB member since 2006-08-09)
Craig,
Welcome to B 
B. Yes you can. Have you tried Security Viewer? It allows you to export a list of all users to excel.
For more information, please perform a search on Security Viewer.
Kashif
Kashif Saeed 
(BOB member since 2004-06-02)
Hi,
Just take care that this won’t work if you manage more than 1000 users 
Regards
Sebastien
You can use the tool available for download here that will allow you to grab user information and load to a flat file. From here, you could load to a DB, export to Excel, report from with Crystal, etc etc:
If you want to get around the 1000 user limitation, either edit the embedded SQL queries in the code to use “select top ####” (5000, 7500, etc) syntax, or there is a registry key that can be edited to override the default 1000 row limitation.
crystal01 
(BOB member since 2006-08-30)