PowerShell to search for domain Computer objects

Question

Post reply

PowerShell to search for domain Computer objects

DBAFahim

SSC Enthusiast

Points: 111
More actions
April 17, 2013 at 5:05 pm

#273170

Comments posted to this topic are about the item PowerShell to search for domain Computer objects

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

aleksbor Valued Member Points: 71 More actions · Answer 1

Hello Fahim,

How is this different from

Get-ADComputer "RAL" | select Name, DistinguishedName | fl

?

Thank you,

AK

DBAFahim SSC Enthusiast Points: 111 More actions · Answer 2

aleksbor (4/30/2013)
...
How is this different from
Get-ADComputer "RAL" | select Name, DistinguishedName | fl
...

In order to use that Cmdlet, I had to activate the ActiveDirectory feature of windows on the querying server.

Personally I wouldn't want to install the ActiveDirectory feature on my SQL Server, which is where I would be querying from, hence I'd be without the "Get-ADComputer".

I tried to import the module alone, but with no luck, maybe there is a way and I just didn't get it.

This is why I wrote that longer script that used commands already available inside my non-AD server.

aleksbor Valued Member Points: 71 More actions · Answer 3

I see. I usually do this sort of thing from my PC. Also, I beleive in PS V3 modules load automatically...

DBAFahim SSC Enthusiast Points: 111 More actions · Answer 4

If I could get your command to work, without installing the AD feature, I'd love to get that working. I agree, my work-around is much less efficient.

Please send me instructions or details I'd love to give it a shot, and update my article.

aleksbor Valued Member Points: 71 More actions · Answer 5

Load one of those (depending on OS):

http://www.microsoft.com/en-in/download/details.aspx?id=34595

and run that command I posted earlier.

DBAFahim SSC Enthusiast Points: 111 More actions · Answer 6

It turns out that I already had the latest version of PowerShell.

However what I needed to do was install a Windows Feature called "RSAT-AD-PowerShell", which then allowed me to run your CMDlet.

Now that I can run the Get-ADComputer cmdlet, how do you wildcard the name ? Or do I have to write that Filter wrapper in Powershell ?

aleksbor Valued Member Points: 71 More actions · Answer 7

You may try something of this sort:

Get-ADComputer -SearchBase "OU=Servers,OU=Computers,DC=you_domain,DC=local" -Filter *

get-help get-adcomputer -examples will show you more examples.

PowerShell to search for domain Computer objects

Cookies on SQLServerCentral