通过powershell读取性能计数器
读取指定文件夹里性能计数器文件的信息,取出各个counter的平均值,存储在csv
param($folderPath="")
function funhelp()
{
$helpText=@"
NAME: PerformanceCounterCalculation)_multipleFile.ps1
This script will loop all the counters and calcualte the average value
PARAMETERS:
-$folderPath Specifies the folder of the .BLG you want to get
SYNTAX:
PerformanceCounterCalculation)_multipleFile.ps1 -folderPath "c:\disk\*"
"@
Write-Host $helpText-ForegroundColor Green
exit
}
#define PerformanceCounter CLASS
$source=@"
public class PerformanceCounter
{
private string computerName;
private string counterPath;
private double value;
private string date;
public PerformanceCounter(string computerName,string counterPath, double value,string date)
{
this.computerName = computerName;
this.counterPath = counterPath;
this.value = value;
this.date=date;
}
public double Value
{
get { return this.value; }
}
public string CounterPath
{
get { return this.counterPath; }
}
public string ComputerName
{
get { return this.computerName; }
}
public string Date
{
get { return this.date; }
}
}
"@
#------------------------------------------------------This script will loop all the counters and calcualte the average value
function Cal([string]$filename)
{
$PathCount=0;
$CounterArray=import-counter $filename
$PathCount=$CounterArray[0].CounterSamples.Count
for($i=0;$i-lt$PathCount;$i++)
{
$total=0
foreach ($singleCounterArrayin$CounterArray)
{
$total=$total+$singleCounterArray.CounterSamples[$i].CookedValue
}
$averageValue=$total/$CounterArray.count
$countPath=$CounterArray[0].CounterSamples[$i].Path;
$countPath=$countPath.Substring(2,$countPath.Length-2);#elminiate the first \\
$computerName=$countPath.Substring(0,$countPath.IndexOf("\"));#get the computername
$countPath=$countPath.Substring($countPath.IndexOf("\"),$countPath.Length-$countPath.IndexOf("\"));#remove the computername
$date=[string]$CounterArray[0].Timestamp.ToString("yyyyMMdd");
$counter=New-Object PerformanceCounter($computerName,$countPath,$averageValue,$date);
$c=$a.add($counter) # $.add operation will output the number of PerformanceCounter, add $c to elimiate the behavior
}
}
if ($folderPath-eq"")#$folderPath can't be empty
{
funhelp
exit
}
$a=New-Object System.Collections.ArrayList
Add-Type -TypeDefinition $source
$blgList=Get-Item $folderPath-include *.blg
$processedNumber=0
foreach($blgin$blgList)
{
$processedNumber=$processedNumber+1
Cal([string]$blg.FullName)
Write-Host $processedNumber"files of "$blgList.count "have been processed"
}
Write-Host "Process done, Please wait..."-ForegroundColor Green
$filename="result"+[system.datetime]::now.ToString("yyyyMMddhhmmss")+".csv"
$a|Export-Csv $filename
Write-Host "Please check"$filename"for detail"-ForegroundColor Green下面是csv文件的效果图
1
2
3
