+1 on ADFIND. Use this instead of DSQUERY. It will make your life a lot easier.
On Wed, Feb 25, 2009 at 1:03 PM, Michael B. Smith < [email protected]> wrote: > Use adfind from www.joeware.net instead of dsquery. > > > > Adfind –default –f > > "(&(objectCategory=Person)(objectClass=User)(homeDirectory=\5c\5cmydirectorypath*))" > -csv sAMAccountName givenName profilePath homeDirectory > > c:\temp\scripts\adinfo\hd.csv > > > > Adfind has been around a long time, much longer than dsquery, and is much > more powerful. Basic syntax for dsquery was basically stolen from adfind. > J > > > > *From:* MarvinC [mailto:[email protected]] > *Sent:* Wednesday, February 25, 2009 12:27 PM > > *To:* NT System Admin Issues > *Subject:* Re: A simple yet...not so simple ?? > > > > This may seem dumb but what's the best way to add additional attributes and > have them delimited in spreadsheet form? It wants to place everything into > one row and I'm tried using commas to no avail. > > > > dsquery * domainroot -limit 3000 -filter > "(&(objectCategory=Person)(objectClass=User)(homeDirectory=\5c\5cmydirectorypath*))" > -attr sAMAccountName givenName profilePath homeDirectory > > c:\temp\scripts\adinfo\hd.csv > > > > tia > > > > > On Wed, Feb 25, 2009 at 10:42 AM, MarvinC <[email protected]> wrote: > > Abso-freakin-YES!! > > > > Thank you sir! > > On Wed, Feb 25, 2009 at 10:16 AM, Michael B. Smith < > [email protected]> wrote: > > You are close. > > > > dsquery * domainroot -filter > "(&(objectCategory=Person)(objectClass=User)(homeDirectory=\5c\5cmyserver))" > -attr sAMAccountName homeDirectory > c:\temp\scripts\adinfo\hdprofile.txt > > > > Notice that I removed an extra slash you had in there. I tested this, it > works. Note that you PROBABLY want a “*” after myserver. You shouldn’t be > able to specify a servername without a share as a home directory… > > > > *From:* MarvinC [mailto:[email protected]] > *Sent:* Wednesday, February 25, 2009 9:17 AM > > > *To:* NT System Admin Issues > > *Subject:* Re: A simple yet...not so simple ?? > > > > Tried that with this and still no luck: > > > > > > dsquery * domainroot -filter > "(&(objectCategory=Person)(objectClass=User)(homedirectory=\5c\5c\myserver$))" > -attr sAMAccountName homeDirectory > c:\temp\scripts\adinfo\hdprofile.csv > > and with this: > > > > > > dsquery * domainroot -filter > "(&(objectCategory=Person)(objectClass=User)(homeDirectory=\5c\5c\myserver))" > -attr sAMAccountName homeDirectory > c:\temp\scripts\adinfo\hdprofile.txt > > > > > > and with this: > > > > dsquery * domainroot -filter > "(&(objectCategory=Person)(objectClass=User)(homeDirectory=\directorypath))" > -attr sAMAccountName homeDirectory > c:\temp\hdir.csv > > > > > What am I missing? > > > > > > On Tue, Feb 24, 2009 at 10:10 PM, KenM <[email protected]> wrote: > > try (homedirectory=\5c\5cdirectorypath) > > > > > > On Tue, Feb 24, 2009 at 9:48 PM, MarvinC <[email protected]> wrote: > > dsquery * domainroot -filter > "(&(objectCategory=Person)(objectClass=User)(homeDirectory=\\directorypath))" > -attr sAMAccountName homeDirectory > c:\temp\hdir.csv > > > > This "simple" query is suppose to write all domain users who homeDirectory > path resides on a particular server. The file gets created and there are no > errors but nothings' written to it. Can someone quide me on what it is I'm > doing wrong? > > > > Any responses appreciated > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
