{"id":16911,"date":"2010-10-05T00:01:00","date_gmt":"2010-10-05T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2010\/10\/05\/use-powershell-to-graph-the-reliability-of-windows-2008-r2\/"},"modified":"2010-10-05T00:01:00","modified_gmt":"2010-10-05T00:01:00","slug":"use-powershell-to-graph-the-reliability-of-windows-2008-r2","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/use-powershell-to-graph-the-reliability-of-windows-2008-r2\/","title":{"rendered":"Use PowerShell to Graph the Reliability of Windows 2008 R2"},"content":{"rendered":"

Summary<\/b>: Microsoft Scripting Guy Ed Wilson shows you how to use Group Policy to enable reliability tracing via Windows PowerShell and Microsoft Graph.<\/p>\n

 <\/p>\n

\"Hey,<\/p>\n

Hey, Scripting Guy! First of all, let me say that yesterday’s article was interesting. We are also looking at attempting to determine server reliability, and I think that the WMI<\/a> Reliability provider may provide just what we need. However, when I attempted to run your commands on our Windows Server 2008 R2 servers, I got an error. Is your code broken? Say it ain’t so!<\/p>\n

— DA<\/p>\n

 <\/p>\n

\"Hey,<\/p>\n

Hello DA, <\/p>\n

Microsoft Scripting Guy Ed Wilson here. Fall in the Deep South is absolutely my favorite time of the year. SQLSaturday<\/a> in Columbia, South Carolina, was a great event. I had the opportunity to meet several people I had been following on Twitter<\/a>, and found new database administrators who are active in the SQL community. In addition to the networking, the sessions were awesome. <\/p>\n

GP, to gain access to the WMI classes that are supplied by the Reliability provider on a Windows Server 2008 R2 computer, you need to first enable the provider via Group Policy. On Windows 7<\/a>, the provider is enabled by default. <\/p>\n

There are two things about Group Policy. The first, as shown in the following image, is that there are several thousand policy settings (luckily there is a Group Policy spreadsheet<\/a> that you can download for reference) in the Group Policy Management Editor.<\/p>\n

\"Image<\/a><\/p>\n

The second thing you need to know about Group Policy is that there is an excellent search feature. Unfortunately, the feature is not called search or even find; it is called filter. The Filter Options dialog box is shown in the following image.<\/p>\n

\"Image<\/a><\/p>\n

After I apply the filter, only the Configure Reliability WMI Providers policy setting remains, as shown in the following image.<\/p>\n

\"Image<\/a><\/p>\n

The Configure Reliability WMI Providers policy setting is a simple setting: enable or disable. This is shown in the following image.<\/p>\n

\"Image<\/a><\/p>\n

After the Group Policy setting has been enabled, you will need to refresh the Group Policy settings on your servers. Updating Group Policy settings can easily be accomplished from the Windows PowerShell console. <\/p>\n

The first thing I need to do is store administrative credentials in a variable. I do this by using the Get-Credential<\/b> cmdlet. A message appears in the Windows PowerShell console as shown here: <\/p>\n

\n
PS<\/span> <\/span>C:\\><\/span> <\/span>$credential<\/span> <\/span>=<\/span> <\/span>Get-Credential<\/span>  <\/p>\n

<\/span>cmdlet<\/span> <\/span>Get-Credential<\/span> <\/span>at<\/span> <\/span>command<\/span> <\/span>pipeline<\/span> <\/span>position<\/span> <\/span>1<\/span> 
<\/span>Supply<\/span> <\/span>values<\/span> <\/span>for<\/span> <\/span>the<\/span> <\/span>following<\/span> <\/span>parameters:<\/span> 
<\/span>Credential<\/span> <\/div>\n<\/blockquote>\n

In addition, the dialog box shown in the following image allows me to securely type the user name and password.<\/p>\n

\"Image<\/a><\/p>\n

I then use the Get-Content<\/b> cmdlet to read a text file that contains a listing of the servers upon which I wish to operate. The text file simply contains each computer name on an individual line as shown in the following image.<\/p>\n

\"Image<\/a><\/p>\n

I pipe the results of the Get-Content<\/b> cmdlet to the ForEach-Object cmdlet<\/a>, and call the Invoke-Command<\/b> cmdlet. I pass the name of the current computer name to the –computername<\/b> parameter, the credential that is stored in the $credential<\/b> variable to the –credential<\/b> parameter, and the gpupdate \/force<\/b> command to the scriptblock<\/b> parameter. The command (which is a single line) is shown here:<\/p>\n

\n
PS<\/span> <\/span>C:\\><\/span> <\/span>Get-Content<\/span> <\/span>C:\\fso\\Servers.txt<\/span> <\/span>|<\/span> <\/span>ForEach-Object<\/span> <\/span>{<\/span> <\/span>Invoke-Command<\/span> <\/span>-ComputerNam<\/span> 
<\/span>e<\/span> <\/span>$_<\/span> <\/span>-Credential<\/span> <\/span>$credential<\/span> <\/span>-ScriptBlock<\/span> <\/span>{<\/span> <\/span>gpupdate<\/span> <\/span>\/force<\/span> <\/span>}<\/span> <\/span>}<\/span> <\/div>\n<\/blockquote>\n

The output from running the command is shown in the following image.<\/p>\n

\"Image<\/a><\/p>\n

As shown in the output above, the computer DC1 was unreachable. A quick ping<\/a> confirms it is up and running. This tells me that Windows PowerShell remoting has not been enabled on that computer. I pop over to the DC1 box, open the Windows PowerShell console, and type enable-psremoting –force (Because DC1 is a server and administrator rights are required to log on to the console, I do not have to open an “elevated” Windows PowerShell console; UAC is disabled on that server.)<\/p>\n

After Group Policy has been updated on the Windows Server 2008 R2 machines, you will not be able to query the servers until several hours have passed, and the machines have had an opportunity to create reliability stability metrics that are retrieved via the Win32_ReliabilityStabilityMetrics<\/a> class. Rather than trying to weed through a bunch of data, it might make sense to write a nice script. A sample of the raw data is shown here:<\/p>\n

\n
PS<\/span> <\/span>C:\\><\/span> <\/span>Get-WmiObject<\/span> <\/span>-Class<\/span> <\/span>win32_reliabilityStabilityMetrics<\/span> <\/span>-ComputerName<\/span> <\/span>hyperv-box<\/span>  <\/p>\n

<\/span>__GENUS<\/span> <\/span>:<\/span> <\/span>2<\/span> 
<\/span>__CLASS<\/span> <\/span>:<\/span> <\/span>Win32_ReliabilityStabilityMetrics<\/span> 
<\/span>__SUPERCLASS<\/span> <\/span>:<\/span> <\/span>Win32_Reliability<\/span> 
<\/span>__DYNASTY<\/span> <\/span>:<\/span> <\/span>Win32_Reliability<\/span> 
<\/span>__RELPATH<\/span> <\/span>:<\/span> <\/span>Win32_ReliabilityStabilityMetrics.TimeGenerated<\/span>=<\/span>“201009241900 
00.000000-000″ 
<\/span>__PROPERTY_COUNT<\/span> <\/span>:<\/span> <\/span>5<\/span> 
<\/span>__DERIVATION<\/span> <\/span>:<\/span> <\/span>{Win32_Reliability}<\/span> 
<\/span>__SERVER<\/span> <\/span>:<\/span> <\/span>HYPERV-BOX<\/span> 
<\/span>__NAMESPACE<\/span> <\/span>:<\/span> <\/span>root\\cimv2<\/span> 
<\/span>__PATH<\/span> <\/span>:<\/span> <\/span>\\\\HYPERV-BOX\\root\\cimv2:Win32_ReliabilityStabilityMetrics.Tim<\/span> 
<\/span>eGenerated<\/span>=<\/span>“20100924190000.000000-000” 
<\/span>EndMeasurementDate<\/span> <\/span>:<\/span> <\/span>20100924190000<\/span>.000000-000<\/span> 
<\/span>RelID<\/span> <\/span>:<\/span> <\/span>{DE0BA634-C7D7-4D80-AEC3-08E604F96B0F}<\/span> 
<\/span>StartMeasurementDate<\/span> <\/span>:<\/span> <\/span>20100924180000<\/span>.000000-000<\/span> 
<\/span>SystemStabilityIndex<\/span> <\/span>:<\/span> <\/span>10<\/span> 
<\/span>TimeGenerated<\/span> <\/span>:<\/span> <\/span>20100924190000<\/span>.000000-000<\/span>  <\/p>\n

<\/span>__GENUS<\/span> <\/span>:<\/span> <\/span>2<\/span> 
<\/span>__CLASS<\/span> <\/span>:<\/span> <\/span>Win32_ReliabilityStabilityMetrics<\/span> 
<\/span>__SUPERCLASS<\/span> <\/span>:<\/span> <\/span>Win32_Reliability<\/span> 
<\/span>__DYNASTY<\/span> <\/span>:<\/span> <\/span>Win32_Reliability<\/span> 
<\/span>__RELPATH<\/span> <\/span>:<\/span> <\/span>Win32_ReliabilityStabilityMetrics.TimeGenerated<\/span>=<\/span>“201009241800 
00.000000-000″ 
<\/span>__PROPERTY_COUNT<\/span> <\/span>:<\/span> <\/span>5<\/span> 
<\/span>__DERIVATION<\/span> <\/span>:<\/span> <\/span>{Win32_Reliability}<\/span> 
<\/span>__SERVER<\/span> <\/span>:<\/span> <\/span>HYPERV-BOX<\/span> 
<\/span>__NAMESPACE<\/span> <\/span>:<\/span> <\/span>root\\cimv2<\/span> 
<\/span>__PATH<\/span> <\/span>:<\/span> <\/span>\\\\HYPERV-BOX\\root\\cimv2:Win32_ReliabilityStabilityMetrics.Tim<\/span> 
<\/span>eGenerated<\/span>=<\/span>“20100924180000.000000-000” 
<\/span>EndMeasurementDate<\/span> <\/span>:<\/span> <\/span>20100924180000<\/span>.000000-000<\/span> 
<\/span>RelID<\/span> <\/span>:<\/span> <\/span>{DE0BA634-C7D7-4D80-AEC3-08E604F96B0F}<\/span> 
<\/span>StartMeasurementDate<\/span> <\/span>:<\/span> <\/span>20100924170000<\/span>.000000-000<\/span> 
<\/span>SystemStabilityIndex<\/span> <\/span>:<\/span> <\/span>10<\/span> 
<\/span>TimeGenerated<\/span> <\/span>:<\/span> <\/span>20100924180000<\/span>.000000-000<\/span> <\/div>\n<\/blockquote>\n

In fact, the best way to view this type of data is to create a chart. The easiest way to create a chart is to use the Microsoft Graph COM object. The use of the Win32_ReliabilityStabilityMetrics<\/b> WMI class and the [Management.ManagementDatetimeConverter]::ToDateTime<\/b> static method were discussed in yesterday’s Hey, Scripting Guy! Blog post<\/a>. <\/p>\n

\n

New-ReliabilityChart.ps1<\/strong><\/p>\n

$computer<\/span> <\/span>=<\/span> “localhost” 
<\/span>$chart<\/span> <\/span>=<\/span> <\/span>New-Object<\/span> <\/span>-ComObject<\/span> <\/span>msgraph.application<\/span> 
<\/span>$chart<\/span>.visible<\/span> <\/span>=<\/span> <\/span>$true<\/span> 
<\/span>$chart<\/span>.datasheet.cells.item(<\/span>1<\/span>,<\/span>1<\/span>)<\/span> <\/span>=<\/span> “Time” 
<\/span>$chart<\/span>.datasheet.cells.item(<\/span>1<\/span>,<\/span>2<\/span>)<\/span> <\/span>=<\/span> “ReliabilityMetric” 
<\/span>$r<\/span> <\/span>=<\/span> <\/span>2<\/span>  <\/p>\n

<\/span>Get-WmiObject<\/span> <\/span>-Class<\/span> <\/span>win32_reliabilityStabilityMetrics<\/span> <\/span>-computername<\/span> <\/span>$computer<\/span>|<\/span> 
<\/span>Select-Object<\/span> <\/span>-First<\/span> <\/span>254<\/span> <\/span>|<\/span> 
<\/span>ForEach-Object<\/span> <\/span>{<\/span> 
  <\/span>$chart<\/span>.datasheet.cells.item(<\/span>$r<\/span>,<\/span>1<\/span>)<\/span> <\/span>=<\/span> <\/span>`<\/span> 
  <\/span>[Management.ManagementDatetimeConverter]::ToDateTime(<\/span>$_<\/span>.TimeGenerated)<\/span> 
  <\/span>$chart<\/span>.datasheet.cells.item(<\/span>$r<\/span>,<\/span>2<\/span>)<\/span> <\/span>=<\/span> <\/span>$_<\/span>.SystemStabilityIndex<\/span> 
<\/span>$r++<\/span> 
<\/span>}<\/span> <\/div>\n<\/blockquote>\n

The $computer<\/b> variable is used to hold the computer name. If the script were to be modified to run against multiple computers at the same time, you would need to modify the chart code to save each chart as the computer name, and maybe the date. The MSDN documentation for the Microsoft Graph object tells you how to save the chart. <\/p>\n

The msgraph.application<\/b> program ID is used to create an instance of the Microsoft Graph application. The returned object is stored in the $chart<\/b> variable. Next, the graph is made visible by setting the visible property to $true<\/b>. This is shown here:<\/p>\n

\n
$chart<\/span> <\/span>=<\/span> <\/span>New-Object<\/span> <\/span>-ComObject<\/span> <\/span>msgraph.application<\/span> 
<\/span>$chart<\/span>.visible<\/span> <\/span>=<\/span> <\/span>$true<\/span> <\/div>\n<\/blockquote>\n

Now I add two column headers: time<\/b> and ReliabilityMetric<\/b>. These go into the first row. I then set the value of $r<\/b> to 2 (for the second row). This is shown here:<\/p>\n

\n
$chart<\/span>.datasheet.cells.item(<\/span>1<\/span>,<\/span>1<\/span>)<\/span> <\/span>=<\/span> “Time” 
<\/span>$chart<\/span>.datasheet.cells.item(<\/span>1<\/span>,<\/span>2<\/span>)<\/span> <\/span>=<\/span> “ReliabilityMetric” 
<\/span>$r<\/span> <\/span>=<\/span> <\/span>2<\/span> <\/div>\n<\/blockquote>\n

I then query the Win32_ReliabilityStabilityMetrics<\/b> WMI class and pipe the results to the Select-Object<\/b> cmdlet to retrieve the first 254 objects (this is because the Microsoft Graph application is limited to 255 points). This is shown here:<\/p>\n

\n
Get-WmiObject<\/span> <\/span>-Class<\/span> <\/span>win32_reliabilityStabilityMetrics<\/span> <\/span>-computername<\/span> <\/span>$computer<\/span>|<\/span> 
<\/span>Select-Object<\/span> <\/span>-First<\/span> <\/span>254<\/span> <\/span>|<\/span> <\/div>\n<\/blockquote>\n

The Foreach-Object<\/b> cmdlet is used to allow us to write to each new row in the chart. This is shown here: <\/p>\n

\n
ForEach-Object<\/span> <\/span>{<\/span> 
  <\/span>$chart<\/span>.datasheet.cells.item(<\/span>$r<\/span>,<\/span>1<\/span>)<\/span> <\/span>=<\/span> <\/span>`<\/span> 
  <\/span>[Management.ManagementDatetimeConverter]::ToDateTime(<\/span>$_<\/span>.TimeGenerated)<\/span> 
  <\/span>$chart<\/span>.datasheet.cells.item(<\/span>$r<\/span>,<\/span>2<\/span>)<\/span> <\/span>=<\/span> <\/span>$_<\/span>.SystemStabilityIndex<\/span> 
<\/span>$r++<\/span> 
<\/span>}<\/span> <\/div>\n<\/blockquote>\n

When the New-ReliabilityChart.ps1 script runs, the chart shown in the following image appears. As you can see, my Windows Server 2008 R2 server that is running Hyper-V currently has perfect reliability. <\/p>\n

\"Image<\/a><\/p>\n

DA, that is all there is to using Windows PowerShell and WMI to work with the Reliability provider. Reliability Week will continue tomorrow when we will talk about parsing reliability data. <\/p>\n

We invite you to follow us on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to us at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

 <\/p>\n

Ed Wilson and Craig Liebendorfer, Scripting Guys<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft Scripting Guy Ed Wilson shows you how to use Group Policy to enable reliability tracing via Windows PowerShell and Microsoft Graph.   Hey, Scripting Guy! First of all, let me say that yesterday’s article was interesting. We are also looking at attempting to determine server reliability, and I think that the WMI Reliability […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[25,152,31,60,3,4,45,6],"class_list":["post-16911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-displaying-output","tag-group-policy","tag-operating-system","tag-performance","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell","tag-wmi"],"acf":[],"blog_post_summary":"

Summary: Microsoft Scripting Guy Ed Wilson shows you how to use Group Policy to enable reliability tracing via Windows PowerShell and Microsoft Graph.   Hey, Scripting Guy! First of all, let me say that yesterday’s article was interesting. We are also looking at attempting to determine server reliability, and I think that the WMI Reliability […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/16911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=16911"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/16911\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=16911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=16911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=16911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}