Hassan110@gmail.com
10-04-2006, 07:36 PM
How can I export all users (with all of thier AD information) in excel
who belong to specific distribution groups?
I tried to use CSVDE -f c:\onlyusers.csv -r objectCategory=person
Richard Mueller
10-06-2006, 04:17 AM
<Hassan110@gmail.com> wrote in message
news:1159987015.002782.295800@h48g2000cwc.googlegroups.com...
> How can I export all users (with all of thier AD information) in excel
> who belong to specific distribution groups?
>
> I tried to use CSVDE -f c:\onlyusers.csv -r objectCategory=person
>
try the filter (watch line wrapping):
r
(&(objectCategory=person)(memberOf=cn=Mygroup,ou=Sales,dc=MyDomain,dc=com))
You must specify the Distinguished Name of the distribution group. In fact,
unless you have members of the group that are not users, you can use:
r (memberOf=cn=Mygroup,ou=Sales,dc=MyDomain,dc=com)
If you need to filter on members of several groups, you can Or them with the
| operator.
--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
Herb Martin
10-06-2006, 02:03 PM
<Hassan110@gmail.com> wrote in message
news:1159987015.002782.295800@h48g2000cwc.googlegroups.com...
> How can I export all users (with all of thier AD information) in excel
> who belong to specific distribution groups?
>
> I tried to use CSVDE -f c:\onlyusers.csv -r objectCategory=person
Works fine here. (Using your exact syntax, copied and pasted to
command line).
What errors did you get?
What is the SPECIFIC problem you experienced including any
error messages and numbers.
We presume you are a Domain Admin? Right?
--
Herb Martin, MCSE, MVP
Accelerated MCSE
http://www.LearnQuick.Com
[phone number on web site]
>