get-content server.txt| foreach {
$strComputer = $_
$colItems = get-wmiobject -class “Win32_NetworkAdapterConfiguration” `
-computername $strComputer | Where{$_.IpEnabled -Match “True”}
foreach ($objItem in $colItems) {
write-host $strComputer ” : ” $objItem.IPAddress
}
}

in the server.txt file, one server per line and no extra space at the end of each server.

Recent Entries

• C# - initialize a variable
• Return a status or value from sp_start_job
• iPhone 3G
• Creating Windows Clustered Resources
• changing sql services password
• sql 2005 connection error
• finding a bunch of server’s ip address
• finding physical servername
• order by asc for two (2) columns
• Finding filesizes

This entry was posted on Tuesday, March 31st, 2009 at 12:40 pm and is filed under sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.