{"id":1186,"date":"2009-03-02T01:00:19","date_gmt":"2009-03-02T09:00:19","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2009\/03\/02\/parse-hosts-file-with-powershell\/"},"modified":"2009-03-02T01:00:19","modified_gmt":"2009-03-02T09:00:19","slug":"parse-hosts-file-with-powershell","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2009\/03\/02\/parse-hosts-file-with-powershell\/","title":{"rendered":"Parse HOSTS file with PowerShell"},"content":{"rendered":"

In a recent discussion in the PowerShell forum at ScriptingAnswers.com<\/a>, a member was trying to parse the HOSTS file on a number of desktops. This is a thankless but probably useful task that seems perfectly suited to a scripted solution. What we came up with was a way to turn entries in the HOSTS file to objects in PowerShell. Once we have an object then we can do all sorts of fun things with it.  Here is an enhanced version of the original solution.<\/p>\n

\n
\n
#PARSE-HOSTS.PS1<\/span><\/pre>\n
Param([string]$computername=$env:computername,<\/pre>\n
          [switch<\/span>]$progress)<\/pre>\n
          <\/pre>\n
  function<\/span> TestPing([string]$address) {<\/pre>\n
    $wmi = Get-WmiObject -query \"SELECT * FROM Win32_PingStatus WHERE Address = '$address'\"<\/span><\/pre>\n
    if<\/span> ($wmi.statuscode -eq<\/span> 0) {<\/pre>\n
        $true<\/pre>\n
    } else<\/span> {<\/pre>\n
        $false<\/pre>\n
    }<\/pre>\n
  }<\/pre>\n
    <\/pre>\n
if<\/span> ($progress) {<\/pre>\n
    $activity=\"Analyzing Hosts file\"<\/span><\/pre>\n
    $status=(\"...on {0}\"<\/span> -f $computername.ToUpper())<\/pre>\n
    Write-Progress -Activity $activity -status $status<\/pre>\n
}<\/pre>\n
 <\/pre>\n
if<\/span> (TestPing $computername) {<\/pre>\n
    #only proceed if computer can be pinged<\/span><\/pre>\n
    $Hosts= \"\\\\$computername\\admin$\\System32\\drivers\\etc\\hosts\"<\/span><\/pre>\n
    if<\/span> ((Get-Item $Hosts -ea \"SilentlyContinue\"<\/span>).Exists) {<\/pre>\n
        #if hosts file is found, then parse it.<\/span><\/pre>\n
        <\/pre>\n
        if<\/span> ($progress) {<\/pre>\n
            $current=\"Parsing $hosts\"<\/span><\/pre>\n
            Write-Progress -Activity $activity -status $status -current $current<\/pre>\n
        }<\/pre>\n
        <\/pre>\n
        #define a regex to return first NON-whitespace character<\/span><\/pre>\n
        [regex]$r=\"\\S\"<\/span><\/pre>\n
        #strip out any lines beginning with # and blank lines<\/span><\/pre>\n
        $HostsData = Get-Content $Hosts | where {<\/pre>\n
         (($r.Match($_)).value -ne<\/span> \"#\"<\/span>) -and ($_ -notmatch<\/span> \"^\\s+$\"<\/span>) -and ($_.Length -gt<\/span> 0)<\/pre>\n
         }<\/pre>\n
        if<\/span> ($HostsData){<\/pre>\n
            #only process if something was found in HOSTS<\/span><\/pre>\n
            $HostsData | foreach<\/span> {<\/pre>\n
                #created named values<\/span><\/pre>\n
                $_ -match<\/span> \"(?<IP>\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3})\\s+(?<HOSTNAME>\\S+)\"<\/span> | Out-Null<\/pre>\n
                $ip=$matches.ip<\/pre>\n
                $hostname=$matches.hostname  <\/pre>\n
                <\/pre>\n
                #get a comment if defined for the line<\/span><\/pre>\n
                if<\/span> ($_.contains(\"#\"<\/span>)) {<\/pre>\n
                    $comment=$_.substring($_.indexof(\"#\"<\/span>)+1)<\/pre>\n
                }<\/pre>\n
                else<\/span> {<\/pre>\n
                    $comment=$null<\/pre>\n
                   }<\/pre>\n
                <\/pre>\n
                #create a blank object<\/span><\/pre>\n
                $obj = New-Object PSObject<\/pre>\n
                <\/pre>\n
                #the computername property could be the name of the computer whose hosts file<\/span><\/pre>\n
                #you are enumerating<\/span><\/pre>\n
                $obj | Add-Member Noteproperty -name \"Computername\"<\/span> -Value $computername.ToUpper()<\/pre>\n
                $obj | Add-Member Noteproperty -name \"IP\"<\/span> -Value $ip<\/pre>\n
                $obj | Add-Member Noteproperty -name \"Hostname\"<\/span> -Value $hostname<\/pre>\n
                $obj | Add-Member Noteproperty -name \"Comment\"<\/span> -Value $comment<\/pre>\n
                <\/pre>\n
                write $obj<\/pre>\n
               } #end ForEach<\/span><\/pre>\n
         } #end If $HostsData<\/span><\/pre>\n
         else<\/span> {<\/pre>\n
            Write-Host (\"{0} has no entries in its HOSTS file.\"<\/span> -f $computername.toUpper()) -foreground Magenta<\/pre>\n
         }<\/pre>\n
    } #end If Hosts exists<\/span><\/pre>\n
    else<\/span> {<\/pre>\n
        Write-Warning \"Failed to find $hosts\"<\/span><\/pre>\n
      }<\/pre>\n
 } #end If TestPing<\/span><\/pre>\n
else<\/span> {<\/pre>\n
    Write-Warning (\"Failed to connect to {0}\"<\/span> -f $computername.ToUpper())<\/pre>\n
}<\/pre>\n
 <\/pre>\n
if<\/span> ($progress) {<\/pre>\n
    Write-Progress -Activity $activity -status $status -completed<\/pre>\n
  }   <\/pre>\n
#end<\/span> of script<\/pre>\n<\/div>\n<\/div>\n
This is a complete script that you would run, not a simple function. The script takes a computer name as a parameter, although it defaults to the local computer. It opens up the HOSTS file via the ADMIN$ share (so file sharing must be enabled) and parses it. Any entries are converted to objects with the IP address, name and comment as properties. The script also has a -progress parameter. If this is specified, then the script will use the Write-Progress<\/strong> cmdlet to let you know what it is doing.  Very useful when you want to use the script like this:<\/p>\n
PS C:\\> get-content desktops.txt | foreach { c:\\scripts\\parse-hosts.ps1 $_ -progress} | Sort Computername | Export-CSV hostsreport.csv<\/font><\/p>\n
Let’s look at the script in a little more detail because there are some features you might want to use in other scripts.<\/p>\n
First off, the script has a nested TestPing function.<\/p>\n
\n
\n
function<\/span> TestPing([string]$address) {<\/pre>\n
    $wmi = Get-WmiObject -query \"SELECT * FROM Win32_PingStatus WHERE Address = '$address'\"<\/span><\/pre>\n
    if<\/span> ($wmi.statuscode -eq<\/span> 0) {<\/pre>\n
        $true<\/pre>\n
    } else<\/span> {<\/pre>\n
        $false<\/pre>\n
    }<\/pre>\n
  }<\/pre>\n<\/div>\n<\/div>\n
Each computer is pinged and processed only if the ping is successful.<\/p>\n
\n
\n
if<\/span> (TestPing $computername) {<\/pre>\n
    #only proceed if computer can be pinged<\/span><\/pre>\n
    $Hosts= \"\\\\$computername\\admin$\\System32\\drivers\\etc\\hosts\"<\/span><\/pre>\n<\/div>\n<\/div>\n
The script then checks to see if a hosts file even exists.<\/p>\n
\n
\n
if<\/span> ((Get-Item $Hosts -ea \"SilentlyContinue\"<\/span>).Exists) {<\/pre>\n
    #if<\/span> hosts file is found, then parse it.<\/pre>\n<\/div>\n<\/div>\n
I have to use the -ErrorAction common parameter with Get-Item<\/strong> to suppress an error message if the file doesn’t exist. Weird, but trust me. Now the fun part.<\/p>\n
I needed a way to skip any lines that are comments or blank. To solve that I turned to regular expressions.<\/p>\n
\n
\n
#define a regex to return first NON-whitespace character<\/span><\/pre>\n
        [regex]$r=\"\\S\"<\/span><\/pre>\n
        #strip out any lines beginning with # and blank lines<\/span><\/pre>\n
        $HostsData = Get-Content $Hosts | where {<\/pre>\n
         (($r.Match($_)).value -ne<\/span> \"#\"<\/span>) -and ($_ -notmatch<\/span> \"^\\s+$\"<\/span>) -and ($_.Length -gt<\/span> 0)<\/pre>\n
         }<\/pre>\n<\/div>\n<\/div>\n
First I created a regular expression object with the pattern “\\S” which indicates any non-whitespace character. So when I pipe the contents of HOSTS to Where-Object<\/strong>, one of the things I’m looking for is a match on the first non-whitespace character. I use the Match()<\/strong> method of the REGEX object, $r. If there is a match, the resulting object’s Value property will indicate what it matched. If it doesn’t equal the comment character “#”, I’m good. The second part of the Where statement is to not match on another regular expression pattern, “^\\s+$”. This pattern is looking for a line that has nothing but whitespace like spaces and tabs. This is different from the last check which is simply looking for lines that have a length greater than 0. This eliminates completely blank lines.<\/p>\n
After all of that, assuming anything was returned what I should have is a line like: <\/p>\n
172.16.10.1     mydomain.com   #test domain<\/font><\/p>\n
What I need to do is parse that using regular expressions to extract the IP, hostname and comment.<\/p>\n
\n
\n
$HostsData | foreach<\/span> {<\/pre>\n
    #created named values<\/span><\/pre>\n
    $_ -match<\/span> \"(?<IP>\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3})\\s+(?<HOSTNAME>\\S+)\"<\/span> | Out-Null<\/pre>\n
    $ip=$matches.ip<\/pre>\n
    $hostname=$matches.hostname  <\/pre>\n<\/div>\n<\/div>\n
I know that the first part will be an IPv4 address so I’ll use a simple regular expression (d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}). After that there can be any number of whitespace characters including spaces and tabs (\\s+) followed by the hostname which is a series of non-whitespace characters (\\S+).  I’m not worried about the comment character because the regular expression will not match on the space after the domain name. But what is that <IP> and <HOSTNAME> stuff?<\/p>\n
In my regular expression pattern I am defining named values for the matches. Recall that PowerShell will automatically create $matches with the results of the regular expression comparison. I’m simply saying assign the IP address pattern to IP and the name pattern to HOSTNAME. This allows me to easily retrieve the matching values which I assign to variables.<\/p>\n
If the line contains a comment it will be at the end of the line.<\/p>\n
\n
\n
if<\/span> ($_.contains(\"#\"<\/span>)) {<\/pre>\n
    $comment=$_.substring($_.indexof(\"#\"<\/span>)+1)<\/pre>\n
}<\/pre>\n
else<\/span> {<\/pre>\n
    $comment=$null<\/pre>\n
   }<\/pre>\n<\/div>\n<\/div>\n
All I need to do is find the # character’s position in the line, and use the Substring()<\/strong> method to retrieve the last part of the line. That’s basically it. All that remains is to create a custom object, define it’s properties and write it to the pipeline.<\/p>\n
\n
\n
#create a blank object<\/span><\/pre>\n
$obj = New-Object PSObject<\/pre>\n
 <\/pre>\n
#the computername property could be the name of the computer whose hosts file<\/span><\/pre>\n
#you are enumerating<\/span><\/pre>\n
$obj | Add-Member Noteproperty -name \"Computername\"<\/span> -Value $computername.ToUpper()<\/pre>\n
$obj | Add-Member Noteproperty -name \"IP\"<\/span> -Value $ip<\/pre>\n
$obj | Add-Member Noteproperty -name \"Hostname\"<\/span> -Value $hostname<\/pre>\n
$obj | Add-Member Noteproperty -name \"Comment\"<\/span> -Value $comment<\/pre>\n
 <\/pre>\n
write $obj<\/pre>\n<\/div>\n<\/div>\n
The rest of the script is self-explanatory error handling.<\/p>\n
I tried to take a lot of things into account. One thing that this script won’t do is return any entries using IPv6 addresses, but since HOSTS is a legacy file I’m trusting that won’t be an issue. <\/p>\n
Even if you don’t need to monitor HOSTS file on your network, I trust you found some useful techniques for your own PowerShell projects.<\/p>\n<\/p>\n
\n
Download Parse-Hosts.ps1 here.<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
In a recent discussion in the PowerShell forum at ScriptingAnswers.com, a member was trying to parse the HOSTS file on a number of desktops. This is a thankless but probably useful task that seems perfectly suited to a scripted solution. What we came up with was a way to turn entries in the HOSTS file to objects in PowerShell. Once we have an object then we can do all sorts of fun things with it.  Here is an enhanced version of the original solution.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[461,242,462,28,463,464,57,275],"class_list":["post-1186","post","type-post","status-publish","format-standard","hentry","category-windows-powershell","tag-hosts","tag-new-object","tag-ping","tag-powershell","tag-regex","tag-regular-expressions","tag-scripting","tag-write-progress"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=1186"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1186\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=1186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=1186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=1186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}