{"id":12041,"date":"2011-11-19T00:01:00","date_gmt":"2011-11-19T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2011\/11\/19\/query-ad-for-computers-and-use-ping-to-determine-status\/"},"modified":"2011-11-19T00:01:00","modified_gmt":"2011-11-19T00:01:00","slug":"query-ad-for-computers-and-use-ping-to-determine-status","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/query-ad-for-computers-and-use-ping-to-determine-status\/","title":{"rendered":"Query AD for Computers and Use Ping to Determine Status"},"content":{"rendered":"

Summary:<\/strong> Learn how to use Windows PowerShell to query Active Directory for computers, ping for status, and display in green\/red.<\/p>\n

 <\/p>\n

Microsoft Scripting Guy Ed Wilson here. While the Scripting Wife and I were out in California speaking to the Microsoft Premier Field Engineers (PFE) about Windows PowerShell, a question arose. The PFE said he had a customer that needed to send a ping to a number of computers. The customer did not need a lot of information about the status, but more of a simple yes or no report on connectivity. Ping was the tool of choice due to simplicity. The problem is that Ping returns too much information. What the customer really wanted was an output that displayed the computer name in green (for up) and in red (for down). A simple status board to display the computer names. One problem, the PFE related, is that the collection of computers to monitor changes on nearly a daily basis. Therefore, the customer wants to query Active Directory for the computer names.<\/p>\n

We left the reception Thursday night, and I went up to the room and put together this script. It could have been a “one-liner” but, it would have been difficult to read, so I spread it out over a couple of different lines. Here is the complete Query Active Directory and Ping Computers script in Windows PowerShell (for ease of use, I uploaded the script to the Scripting Guys Script Repository<\/a>):<\/p>\n

Query Active Directory and Ping Computers<\/b><\/p>\n

Import-Module active*<\/p>\n

$rtn = $null<\/p>\n

Get-ADComputer -Filter * |<\/p>\n

ForEach-Object {<\/p>\n

  $rtn = Test-Connection -CN $_.dnshostname -Count 1 -BufferSize 16 -Quiet<\/p>\n

  IF($rtn -match ‘True’) {write-host -ForegroundColor green $_.dnshostname}<\/p>\n

  ELSE { Write-host -ForegroundColor red $_.dnshostname }<\/p>\n

}<\/p>\n

The first thing the Query Active Directory and Ping Computers script does is import the ActiveDirectory<\/b> module. I have written about this module quite a bit. In the Install Active Directory Management Service for Easy PowerShell Access <\/i>post<\/a>, I go into detail about the requirements to set up the Active Directory Management gateway. Next, I set the value of the $rtn<\/b> variable to $null<\/b>. This helps to avoid problems if there is already a $rtn<\/b> variable with a different value.<\/p>\n

I then use the Get-ADComputer<\/b> cmdlet from the ActiveDirectory<\/b> module (I have used the Get-ADComputer<\/b> cmdlet numerous times on the Hey, Scripting Guy! Blog<\/a>) to return all computers. The following line of code returns an ADComputer<\/b> object from the Microsoft.ActiveDirectory.Management<\/b> namespace:<\/p>\n

Get-ADComputer -Filter *<\/p>\n

By default, the ADComputer<\/b> object contains only a few properties. The default properties are shown here:<\/p>\n

DistinguishedName                                                                   <\/p>\n

DNSHostName                                                                         <\/p>\n

Enabled                                                                             <\/p>\n

Name                                                                                <\/p>\n

ObjectClass                                                                         <\/p>\n

ObjectGUID                                                                          <\/p>\n

SamAccountName                                                                      <\/p>\n

SID                                                                                 <\/p>\n

UserPrincipalName  <\/p>\n

Other properties exist on a computer object. For example, the following figure illustrates properties that contain a value for the W7Client computer. The figure from ADSI Edit is shown here.<\/p>\n

\"Image<\/a><\/p>\n

To obtain access to additional property values, I need to add them to the property <\/i>parameter (the reason for the small subset of properties returned by default is because of performance concerns). Here is an example of returning the DNSHostname<\/b> and the lastlogon<\/b> attribute values.<\/p>\n

Get-ADComputer -Filter * -Properties lastlogon | select dnshostname, lastlogon<\/p>\n

Unfortunately, the Test-Connection<\/b> cmdlet does not accept piped input, and I need to use the Foreach-Object<\/b> cmdlet to walk through the collection of ADComputer<\/b> objects and ping the DNSHostname<\/b> of each computer. To speed things along, I send one ping and reduce the BufferSize<\/b>. I store the results in a variable named $rtn<\/b>:<\/p>\n

ForEach-Object {<\/p>\n

  $rtn = Test-Connection -CN $_.dnshostname -Count 1 -BufferSize 16 –Quiet<\/p>\n

The Test-Connection returns a True<\/b> <\/i>or a False<\/b> <\/i>depending upon whether the connection succeeds. But unfortunately, it is a string and not a true Boolean value<\/a>. Therefore, in my decision portion of the script, I used the IF<\/b> statement and did a match on the string True<\/b>. <\/i>If Test-Connection<\/b> returns true, I display the DNSHostname of the computer in green. Otherwise, I display the DNSHostname of the computer in red. This portion of the script is shown here:<\/p>\n

ForEach-Object {<\/p>\n

  $rtn = Test-Connection -CN $_.dnshostname -Count 1 -BufferSize 16 -Quiet<\/p>\n

  IF($rtn -match ‘True’) {write-host -ForegroundColor green $_.dnshostname}<\/p>\n

  ELSE { Write-host -ForegroundColor red $_.dnshostname }<\/p>\n

}<\/p>\n

The script and associated output are shown in the following figure.<\/p>\n

\"Image<\/a><\/p>\n

 <\/p>\n

Well, that is about all there is to querying Active Directory Domain Services for computer accounts, and pinging them to see if they are up and running or not. Join me tomorrow for more cool Windows PowerShell stuff.<\/p>\n

I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

 <\/p>\n

Ed Wilson, Microsoft Scripting Guy<\/b><\/p>\n

 <\/b><\/p>\n<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Learn how to use Windows PowerShell to query Active Directory for computers, ping for status, and display in green\/red.   Microsoft Scripting Guy Ed Wilson here. While the Scripting Wife and I were out in California speaking to the Microsoft Premier Field Engineers (PFE) about Windows PowerShell, a question arose. The PFE said he […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[7,46,25,3,4,61,45],"class_list":["post-12041","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-active-directory","tag-computer-accounts","tag-displaying-output","tag-scripting-guy","tag-scripting-techniques","tag-weekend-scripter","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Learn how to use Windows PowerShell to query Active Directory for computers, ping for status, and display in green\/red.   Microsoft Scripting Guy Ed Wilson here. While the Scripting Wife and I were out in California speaking to the Microsoft Premier Field Engineers (PFE) about Windows PowerShell, a question arose. The PFE said he […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=12041"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12041\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=12041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=12041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=12041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}