{"id":9531,"date":"2012-05-04T00:01:00","date_gmt":"2012-05-04T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2012\/05\/04\/using-performance-counters-with-the-out-gridview-cmdlet\/"},"modified":"2012-05-04T00:01:00","modified_gmt":"2012-05-04T00:01:00","slug":"using-performance-counters-with-the-out-gridview-cmdlet","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/using-performance-counters-with-the-out-gridview-cmdlet\/","title":{"rendered":"Using Performance Counters with the Out-GridView Cmdlet"},"content":{"rendered":"

Summary<\/b>: Microsoft Scripting Guy, Ed Wilson demonstrates how to use the Out-GridView<\/b> cmdlet with performance counter information.<\/p>\n

\"Hey, Hey, Scripting Guy! I have a question, and hopefully you will not think it is a stupid one. During the 2012 Scripting Games, one of the events had to do with using performance counters. I thought that was a pretty good idea, so I started playing around with them. Then I saw your blogs about using the Out-GridView<\/b> cmdlet, and I thought it would make sense to combine the two: performance counters and the Out-GridView<\/b> cmdlet. The problem is that it seems to not work. So is this a known bug, or was it never intended to work together at all?<\/p>\n

—CT<\/p>\n

\"Hey, Hello CT,<\/p>\n

Microsoft Scripting Guy, Ed Wilson, is here. Today is an awesome day. I had a great meeting with the TechEd Connect Zone people about the Scripting Guys booth at Microsoft TechEd 2012<\/a>. TechEd 2012 will be in Orlando, Florida in the United States, and it will run June 11–14. I grew up in Florida, and I am excited to have the chance to go “home” again. In fact, the Scripting Wife and I are going to maximize our time in the sunshine state. I am speaking at SQL Saturday in Pensacola, Florida<\/a> on June 9 on the way to Orlando. On the way home, we are stopping in Jacksonville, Florida on June 16 where I will be speaking at the Jacksonville IT Pro Camp<\/a>.  <\/p>\n

The problem of Out-GridView and performance info<\/h2>\n

CT, using the Out-GridView<\/b> cmdlet to view performance information in an easy-to-manipulate grid control is not a bad idea, and certainly, it works. The problem is that you need to understand a bit more about the underlying performance objects that are returned by the Get-Counter<\/b> cmdlet.<\/p>\n

Note<\/b>   I have written a number of blogs about using Windows PowerShell and performance counters. Please refer to this list of blog posts<\/a> for additional information about this extremely important subject.<\/p>\n

CT, if you pipe the direct results of the Get-Counter<\/b> cmdlet to the Out-GridView<\/b> cmdlet, you end up with a complex object in the CounterSamples <\/i>field. This effectively limits what you can do with the grid control. Here is an example of what you are probably attempting to do (I have used ogv<\/b> as an alias for the Out-GridView<\/b> cmdlet).<\/p>\n

Get-Counter -ListSet processor | Get-Counter | ogv<\/p>\n

The resulting grid control is shown here. Note that when I attempt to use the filter for the grid control, nothing filters based on the string User. <\/i>This indicates the inability of the grid control to effectively filter output.<\/p>\n

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

Examine the members of the object<\/h2>\n

To provide the Get-GridView<\/b> cmdlet with access to the specific counter information, it is first required to determine where the information resides. To look inside the PerformanceCounterSampleSet<\/b> merely demands piping the result from the Get-Counter<\/b> cmdlet to the Get-Member<\/b> cmdlet. When we examine the members of the PerformanceCounterSampleSet<\/b> object, two properties appear promising. The members of the PerformanceCounterSampleSet <\/b>object are shown here.<\/p>\n

PS C:\\> Get-Counter -ListSet processor | Get-Counter -MaxSamples 1 | Get-Member<\/p>\n

 <\/p>\n

   TypeName: Microsoft.PowerShell.Commands.GetCounter.PerformanceCounterSampleSet<\/p>\n

 <\/p>\n

Name           MemberType     Definition<\/p>\n

—-           ———-     ———-<\/p>\n

Equals         Method         bool Equals(System.Object obj)<\/p>\n

GetHashCode    Method         int GetHashCode()<\/p>\n

GetType        Method         type GetType()<\/p>\n

ToString       Method         string ToString()<\/p>\n

CounterSamples Property       Microsoft.PowerShell.Commands.GetCounter.Performanc…<\/p>\n

Timestamp      Property       System.DateTime Timestamp {get;set;}<\/p>\n

Readings       ScriptProperty System.Object Readings {get=$strPaths = “”…<\/p>\n<\/p>\n

The first property that appears promising is the Readings<\/b> <\/i>property. To examine further the Readings<\/b> <\/i>property, expand it and send the output to the Get-Member<\/b> cmdlet. This technique is shown here.<\/p>\n

PS C:\\> Get-Counter -ListSet processor | Get-Counter -MaxSamples 1 | select -ExpandProperty readings | Get-Member<\/p>\n

 <\/p>\n

   TypeName: System.String<\/p>\n

 <\/p>\n

Name             MemberType            Definition<\/p>\n

—-             ———-            ———-<\/p>\n

Clone            Method                System.Object Clone()<\/p>\n

CompareTo        Method                int CompareTo(System.Object value), int Co…<\/p>\n

Contains         Method                bool Contains(string value)<\/p>\n

CopyTo           Method                System.Void CopyTo(int sourceIndex, char[]…<\/p>\n

EndsWith         Method                bool EndsWith(string value), bool EndsWith…<\/p>\n

Equals           Method                bool Equals(System.Object obj), bool Equal…<\/p>\n

GetEnumerator    Method                System.CharEnumerator GetEnumerator()<\/p>\n

GetHashCode      Method                int GetHashCode()<\/p>\n

GetType          Method                type GetType()<\/p>\n

GetTypeCode      Method                System.TypeCode GetTypeCode()<\/p>\n

IndexOf          Method                int IndexOf(char value), int IndexOf(char …<\/p>\n

IndexOfAny       Method                int IndexOfAny(char[] anyOf), int IndexOfA…<\/p>\n

Insert           Method                string Insert(int startIndex, string value)<\/p>\n

IsNormalized     Method                bool IsNormalized(), bool IsNormalized(Sys…<\/p>\n

LastIndexOf      Method                int LastIndexOf(char value), int LastIndex…<\/p>\n

LastIndexOfAny   Method                int LastIndexOfAny(char[] anyOf), int Last…<\/p>\n

Normalize        Method                string Normalize(), string Normalize(Syste…<\/p>\n

PadLeft          Method                string PadLeft(int totalWidth), string Pad…<\/p>\n

PadRight         Method                string PadRight(int totalWidth), string Pa…<\/p>\n

Remove           Method                string Remove(int startIndex, int count), …<\/p>\n

Replace          Method                string Replace(char oldChar, char newChar)…<\/p>\n

Split            Method                string[] Split(Params char[] separator), s…<\/p>\n

StartsWith       Method                bool StartsWith(string value), bool Starts…<\/p>\n

Substring        Method                string Substring(int startIndex), string S…<\/p>\n

ToCharArray      Method                char[] ToCharArray(), char[] ToCharArray(i…<\/p>\n

ToLower          Method                string ToLower(), string ToLower(System.Gl…<\/p>\n

ToLowerInvariant Method                string ToLowerInvariant()<\/p>\n

ToString         Method                string ToString(), string ToString(System….<\/p>\n

ToUpper          Method                string ToUpper(), string ToUpper(System.Gl…<\/p>\n

ToUpperInvariant Method                string ToUpperInvariant()<\/p>\n

Trim             Method                string Trim(Params char[] trimChars), stri…<\/p>\n

TrimEnd          Method                string TrimEnd(Params char[] trimChars)<\/p>\n

TrimStart        Method                string TrimStart(Params char[] trimChars)<\/p>\n

Chars            ParameterizedProperty char Chars(int index) {get;}<\/p>\n

Length           Property              System.Int32 Length {get;}<\/p>\n<\/p>\n

As you can see, the resulting objects are strings. The conversion to a string might be useful in some situations, but it does not facilitate additional processing as easily as a different type of object. Therefore, examine the CounterSamples<\/b> <\/i>property. When it is piped to the Get-Member<\/b> cmdlet, the CounterSamples<\/b> <\/i>property appears much more interesting than a simple string. This technique is shown here.<\/p>\n

PS C:\\> Get-Counter -ListSet processor | Get-Counter -MaxSamples 1 | select -ExpandProperty countersamples | Get-Member -MemberType property<\/p>\n

 <\/p>\n

   TypeName: Microsoft.PowerShell.Commands.GetCounter.PerformanceCounterSample<\/p>\n

 <\/p>\n

Name             MemberType Definition<\/p>\n

—-             ———- ———-<\/p>\n

CookedValue      Property   System.Double CookedValue {get;set;}<\/p>\n

CounterType      Property   System.Diagnostics.PerformanceCounterType CounterType…<\/p>\n

DefaultScale     Property   System.UInt32 DefaultScale {get;set;}<\/p>\n

InstanceName     Property   System.String InstanceName {get;set;}<\/p>\n

MultipleCount    Property   System.UInt32 MultipleCount {get;set;}<\/p>\n

Path             Property   System.String Path {get;set;}<\/p>\n

RawValue         Property   System.UInt64 RawValue {get;set;}<\/p>\n

SecondValue      Property   System.UInt64 SecondValue {get;set;}<\/p>\n

Status           Property   System.UInt32 Status {get;set;}<\/p>\n

TimeBase         Property   System.UInt64 TimeBase {get;set;}<\/p>\n

Timestamp        Property   System.DateTime Timestamp {get;set;}<\/p>\n

Timestamp100NSec Property   System.UInt64 Timestamp100NSec {get;set;}<\/p>\n

 <\/p>\n

To test the CounterSamples<\/b> <\/i>property to see if it contains the requisite information, use the command that is shown here.<\/p>\n

Get-Counter -ListSet processor | Get-Counter -MaxSamples 1 | select -ExpandProperty countersamples  | select path, timestamp, cookedvalue<\/p>\n

When the command runs, it displays the output shown here.<\/p>\n

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

To permit working with multiple performance counter sets, store the information that is gathered into a variable. When the variable contains the performance information, pipe the output to the Out-GridView<\/b> cmdlet. (The %<\/b> sign is an alias for the Foreach-Object<\/b> cmdlet and ogv<\/b> is an alias for Out-GridView<\/b>).<\/p>\n

$sample = Get-Counter -ListSet processor | Get-Counter -SampleInterval 1 -MaxSamples 10<\/p>\n

$sample | % { $_.countersamples } | select path, timestamp, cookedvalue | ogv<\/p>\n

When the grid-view control appears, use either the quick Filter<\/b> <\/i>or the Add Criteria<\/b> <\/i>technique to parse the resulting performance information. The following image illustrates using the Add Criteria<\/b> <\/i>technique to find only cooked values that are greater than 100 and paths that contain the word interrupts. <\/i>Because the performance counter paths are very descriptive, it is easy to find the desired information.<\/p>\n

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

CT, that is all there is to using the Out-GridView<\/b> cmdlet with performance counter information. Join me tomorrow for the Weekend Scripter.<\/p>\n

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

Ed Wilson, Microsoft Scripting Guy<\/b> <\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft Scripting Guy, Ed Wilson demonstrates how to use the Out-GridView cmdlet with performance counter information.  Hey, Scripting Guy! I have a question, and hopefully you will not think it is a stupid one. During the 2012 Scripting Games, one of the events had to do with using performance counters. I thought that was […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[51,60,3,4,45],"class_list":["post-9531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-getting-started","tag-performance","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Microsoft Scripting Guy, Ed Wilson demonstrates how to use the Out-GridView cmdlet with performance counter information.  Hey, Scripting Guy! I have a question, and hopefully you will not think it is a stupid one. During the 2012 Scripting Games, one of the events had to do with using performance counters. I thought that was […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/9531","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\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=9531"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/9531\/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=9531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=9531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=9531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}