Try this Adfind –default –f "&(objectCategory=Person)(objectClass=User)(homeDirectory=\5c\5cmyServer*)" sAMAccountName givenName homeDirectory -csv -nodn -nolabel > c:\temp\scripts\adinfo\hd.csv
On Wed, Feb 25, 2009 at 1:39 PM, MarvinC <[email protected]> wrote: > Adfind for some reason returns the dn of every object in AD and instead of > displaying the attributes pertaining to that server it populates those rows > with sAMAccountName, which in turn causes the file to grow to 64MB. So I end > up with the following: > > Adfind –default –f > "(&(objectCategory=Person)(objectClass=User)(homeDirectory=\5c\5cmyServer*))" > -csv sAMAccountName givenName homeDirectory > c:\temp\scripts\adinfo\hd.csv > > I've tried this with and without the commas. > > thanks > > On Wed, Feb 25, 2009 at 1:20 PM, KenM <[email protected]> wrote: > >> +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/> ~
