ok, I did this because I was curious to see if I could, not because
it's better/worse. ADquery is probably faster. I tested this on our
internal file pats and it worked.
Requires: Powershell v1, Quest AD cmdlets
# Get the users into a local variable, you can limit with a -searchroot switch
PS: > $users = Get-QADusers -SizeLimit 3000
# Filter by criterea, select output information (the -notype cleans up
the first line of output)
PS:\> $users | where { $_.homedirectory -like
"\\5c\5cmydirectorypath*" } | select samaccountname, givenName,
profilepath,
homedirectory | Export-Csv ./test.csv -notype
Steven
On Wed, Feb 25, 2009 at 10:20 AM, 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/> ~
