{"id":4232,"date":"2013-01-31T00:01:00","date_gmt":"2013-01-31T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2013\/01\/31\/create-a-custom-hyper-v-resource-metering-reset-report\/"},"modified":"2013-01-31T00:01:00","modified_gmt":"2013-01-31T00:01:00","slug":"create-a-custom-hyper-v-resource-metering-reset-report","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/create-a-custom-hyper-v-resource-metering-reset-report\/","title":{"rendered":"Create a Custom Hyper-V Resource Metering Reset Report"},"content":{"rendered":"

Summary:<\/strong> Microsoft Scripting Guy, Ed Wilson, shows you how to create a custom Hyper-V Resource Metering reset report by using Windows PowerShell 3.0.<\/span><\/p>\n

Microsoft Scripting Guy, Ed Wilson, is here. Well, I found a pretty cool Pandora app for my Windows RT Surface<\/a>, and so I am listening to a cool Rolling Stones song as I type this. Actually I am surprised at the quality of the music my little Surface RT is spewing out.<\/p>\n

United States FTC disclaimer:<\/a> The Microsoft Scripting Guys work for the Microsoft Corporation. I have been provided with a Windows Surface RT. In addition, the Microsoft Corporation provides me a salary, health insurance, bonus, U.S. national holidays off, and annual leave. The Microsoft Corporation, however, has not purchased for me the Bluetooth wedge mouse<\/a> or type cover<\/a> that I use with my Surface. In addition, the Microsoft Corporation did not buy the Windows Surface RT that the Scripting Wife uses.<\/p>\n

Anyway, I am playing around this morning, happy that so far I have no meetings either today or tomorrow. In fact, the week is shaping up tremendously … and the Scripting Wife and I are planning on heading out on Friday night to see our friends perform at a local club tomorrow evening. We generally do not hang out with people who do not do Windows PowerShell, so this will be sort of a different experience.<\/p>\n

Working with the virtual machine metering report<\/h2>\n

The VMMeteringReportForVirtualMachine<\/strong> object does not display the amount of time that has lapsed since the Resource Metering was last reset.<\/p>\n

Note<\/strong>   See my Use PowerShell to Reset Hyper-V Resource Metering<\/a> Blog post from Tuesday for more information about resetting the Resource Metering report.<\/p>\n

It dawned on me that the MeteringDuration<\/strong> property contains a TimeSpan<\/strong> object. I confirmed this by piping to Get-Member<\/strong> as shown here.<\/p>\n

14:16 C:\\> get-vm * | Measure-VM | gm -Name MeteringDuration<\/p>\n

TypeName: Microsoft.HyperV.PowerShell.VMMeteringReportForVirtualMachine<\/p>\n

Name             MemberType Definition<\/p>\n

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

MeteringDuration Property   System.Nullable[timespan] MeteringDuration {get;}<\/p>\n

So, I decided to pipe the Get-VM<\/strong> command to the Measure-VM<\/strong> cmdlet and then create a custom object. I named one property TimeSpan<\/strong>, and I cast the MeteringDuration<\/strong> property to a [timespan] object. The code is shown here.<\/p>\n

Get-VM -vmname * | Measure-VM |<\/p>\n

    select-Object vmname,<\/p>\n

     @{LABEL=”Timespan”;EXPRESSION={[timespan]$_.MeteringDuration}}<\/p>\n

When I run the code, the following output is shown.<\/p>\n

VMName                                            Timespan                                       <\/p>\n

——                                            ——–                                       <\/p>\n

sql1                                              02:49:51.1750000                               <\/p>\n

DC1                                               02:49:51.1760000                                <\/p>\n

C2                                                02:49:51.1530000                               <\/p>\n

c1                                                02:49:51.1140000                               <\/p>\n

 <\/p>\n

The big problem with this output is that I have no idea if the TimeSpan<\/strong> represents 2 days or 2 hours. Well, I guess the 49 would probably be minutes or seconds, and the 1750000 is probably something like ticks, but it would be nice to see the TimeSpan<\/strong> expanded.<\/p>\n

Creating a new object with TimeSpan details<\/h2>\n

So, I decide I want to create a new object that expands the Days<\/strong>, Hours<\/strong>, and Minutes<\/strong> properties from the TimeSpan<\/strong> object. Because I now have a custom object that contains the VMName<\/strong> and a TimeSpan<\/strong> object, it is pretty easy for me to create the desired object. I cannot pipe directly to the New-Object<\/strong> cmdlet, but I can pipe to the Foreach-Object<\/strong> cmdlet.<\/p>\n

So, I throw the Foreach-Object<\/strong> cmdlet into the mixture, and in the associated ScriptBlock, I add my New-Object<\/strong> cmdlet. I can specify properties by using a HashTable notation. So first off, I create a property named name<\/strong>, <\/em>and I assign the value from the VMName<\/strong> property of my previous object. Now I use the TimeSpan<\/strong> property from my previous object, and I directly access the Days<\/strong>, Hours<\/strong>, and Minutes<\/strong>. The last step is to choose the type of object—for this, the psobject<\/strong> type is fine. Here is the code I created.<\/p>\n

Get-VM -vmname * | Measure-VM |<\/p>\n

    select-Object vmname,<\/p>\n

     @{LABEL=”Timespan”;EXPRESSION={[timespan]$_.MeteringDuration}} |<\/p>\n

    Foreach-Object {<\/p>\n

       New-Object -Property @{<\/p>\n

        Name=$_.vmname;<\/p>\n

        Days=$_.TimeSpan.Days;<\/p>\n

        Hours=$_.TimeSpan.hours<\/p>\n

        Minutes=$_.timespan.minutes} -type psobject<\/p>\n

       }<\/p>\n

When I run the above code, the output shown here displays in the output pane on my Windows PowerShell ISE.<\/p>\n

                    Hours                     Days                  Minutes Name                  <\/p>\n

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

                       3                        0                       51 sql1                  <\/p>\n

                       3                        0                       51 DC1                   <\/p>\n

                       3                        0                       51 C2                    <\/p>\n

                       3                        0                       51 c1                    <\/p>\n

Hmm, the output is what I want, but the order is all messed up. Oh well, I guess I will need to use Format-Table<\/strong> to fix up the formatting.<\/p>\n

Formatting the output<\/h2>\n

The problem with the previous output is that I wanted the Name<\/strong> of the virtual machine, and then I wanted the Days<\/strong>, Hours<\/strong>, and Minutes<\/strong> to display. I could have just put those properties in order and use the Format-Table<\/strong>, but because I am playing around, I decided to do something better.<\/p>\n

One of the seldom used parameters for the Format-Table<\/strong> cmdlet is the GroupBy<\/strong> parameter. Well, did you know I could supply a ScriptBlock for the GroupBy<\/strong> parameter? If you did know that, have you forgotten it? Well, I decided to add a ScriptBlock for the GroupBy<\/strong> parameter. So, I group by Computer Name<\/strong>, but I change the Label to “Time Since Last VM Report” and then I pick up the name of the virtual machine. Here is the code—it is cool!<\/p>\n

        Format-table -property days, hours, minutes -AutoSize -GroupBy @{<\/p>\n

        Label=”Time since last VM Report”;<\/p>\n

        Expression={$_.name} }<\/p>\n

 The output is shown in the image that follows.<\/p>\n

The complete Get-VMResourceReportConvertToObjectFormatTable.ps1 is shown here.<\/p>\n

get-vm -vmname * | Measure-VM |<\/p>\n

    select-Object vmname,<\/p>\n

     @{LABEL=”Timespan”;EXPRESSION={[timespan]$_.MeteringDuration}} |<\/p>\n

    Foreach-Object {<\/p>\n

       New-Object -Property @{<\/p>\n

        Name=$_.vmname;<\/p>\n

        Days=$_.TimeSpan.Days;<\/p>\n

        Hours=$_.TimeSpan.hours<\/p>\n

        Minutes=$_.timespan.minutes} -type psobject<\/p>\n

       } |<\/p>\n

       Format-table -property days, hours, minutes -AutoSize -GroupBy @{<\/p>\n

        Label=”Time since last VM Report”;<\/p>\n

        Expression={$_.name} }<\/p>\n

I uploaded the complete script to the Scripting Guys Script Repository<\/a>. This should make it easy for you to download and play with the code. Hope you have an awesome day.<\/p>\n

Join me tomorrow when I will talk about more cool Windows PowerShell stuff.<\/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<\/strong> <\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft Scripting Guy, Ed Wilson, shows you how to create a custom Hyper-V Resource Metering reset report by using Windows PowerShell 3.0. Microsoft Scripting Guy, Ed Wilson, is here. Well, I found a pretty cool Pandora app for my Windows RT Surface, and so I am listening to a cool Rolling Stones song as I […]<\/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":[25,271,409,3,4,45],"class_list":["post-4232","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-displaying-output","tag-hyper-v","tag-objects","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Microsoft Scripting Guy, Ed Wilson, shows you how to create a custom Hyper-V Resource Metering reset report by using Windows PowerShell 3.0. Microsoft Scripting Guy, Ed Wilson, is here. Well, I found a pretty cool Pandora app for my Windows RT Surface, and so I am listening to a cool Rolling Stones song as I […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/4232","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=4232"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/4232\/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=4232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=4232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=4232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

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