Guest UselessUser Posted January 19, 2008 Posted January 19, 2008 Hi all, I recent posted a question which Richard Mueller helped with so I am posting my next question that follows on in attempt to get some more help... I currently have a need to enumerate various groups for reporting/security/auditing purposes and basically populate Excel spreadsheets with the details. For example recently I had to find out which users with mailboxes had allow dial in access on their accounts for which I did the following: dsquery -filter "(&(objectCategory=user)(msExchHomeServerName=*)(userAccountControl:1.2.840.113556.1.4.803:=2))" > c:\result.txt Which I then imported into Excel... Is there any other/better way of doing this... in an ideal world I guess I would like to create the filter in ADUC and then just be able to copy the results out of the results pane and into Excel.... can anyone help??
Recommended Posts