Richard Mueller - Auditing group membership??

[Guest UselessUser]

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