[实务运用] 实作Powershell 监控各主机Disk Usage Health

如何从监控主机透过Powershell 指令将各主机磁碟使用率产出成报表

市面上有很多各式各样的监控软体，也有很多精美的报表可以拿来套用

但如果被要求不能使用第三方软体也不能随意变更资料库时该怎么办？

今天就来分享一个”小资” 工程师如何使用Powershell 及html 监控各主机磁碟使用率并产出简单的精美报表

首先我们用ps 读取list 再从各主机win32_logicaldisk 取得磁碟使用空间并将资料格式化 html 组成报表

结束…

就这么简单XD

废话不多说直接分享 source code 自行修改运用

$a = "<style>"
$a = $a + "BODY{font-family: Arial;background-color:#D4FFFF;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:#78FF78;}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:#EBEBFF;}"
$a = $a + "TD:nth-child(1) {text-align: left;}"
$a = $a + "TD:nth-child(2) {text-align: center;}"
$a = $a + "TD:nth-child(3) {text-align: right;}"
$a = $a + "TD:nth-child(4) {text-align: right;}"
$a = $a + "TD:nth-child(5) {text-align: right;}"
$a = $a + "</style>"

Set-ExecutionPolicy Unrestricted -Force

$File = Get-Content -Path .\Servers.txt

$DiskReport = ForEach ($Servernames in ($File)) {Get-WmiObject win32_logicaldisk <#-Credential $RunAccount#> `
-ComputerName $Servernames -Filter "Drivetype=3" -ErrorAction SilentlyContinue} 

$frag = $DiskReport | Select-Object @{Label = "Server_Name";Expression = {$_.SystemName}}, `
@{Label = "Drive_Letter";Expression = {$_.DeviceID}}, `
@{Label = "Total_Capacity_GB";Expression = {"{0:N1}" -f( $_.Size / 1gb)}}, `
@{Label = "Free_Space_GB";Expression = {"{0:N1}" -f( $_.Freespace / 1gb ) }}, `
@{Label = 'Free_Space_%'; Expression = {"{0:P0}" -f ($_.freespace/$_.size)}} | `
select -Property Server_Name, Drive_Letter, Total_Capacity_GB, Free_Space_GB, Free_Space_% | `
ConvertTo-HTML -AS Table -Fragment -PreContent '<h2>Disk Information</h2>' | Out-String

ConvertTo-HTML -head $a -PostContent $frag -PreContent "<h1>SQL Server Disk Heatlh Check Report</h1>" | Out-File .\DiskHeatlhReport.html