Microsoft® SQL Server® 2012 Bible

780

Part V: Enterprise Data Management

Workgroup | format-list

gwmi -query "select * from

Win32_OperatingSystem" -computername $svr | select Name,

Version, FreePhysicalMemory, OSLanguage, OSProductSuite,

OSType, ServicePackMajorVersion,

ServicePackMinorVersion | format-list

gwmi -query "select * from

Win32_PhysicalMemory" -computername $svr | select Name,

Capacity, DeviceLocator, Tag | format-table -Autosize

gwmi -query "select * from Win32_LogicalDisk

where DriveType=3" -computername $svr | select Name, FreeSpace,

Size | format-table -Autosize

}

$servers = get-content 'servers.txt'

foreach ($server in $servers) {

$results = gwmi -query "select StatusCode from Win32_PingStatus

where Address = '$server'"

$responds = $false

foreach ($result in $results) {

if ($result.statuscode -eq 0) {

$responds = $true

break

}

}

if ($responds) {

getwmiinfo $server

} else {

Write-Output "$server does not respond"

}

}

The results of this script look like this:

Name : POSHSQL

Model : 43192PU

Manufacturer : LENOVO

Description : AT/AT COMPATIBLE

DNSHostName : POSHSQL

LISTING 30-2 (continued)

c30.indd 780c30.indd 780 7/31/2012 9:46:22 AM7/31/2012 9:46:22 AM

http://www.it-ebooks.info