Azure EA Viewing the use of sub-accounts

Tag: Blank target border style title

The Azure EA user typically creates a sub-account and then assigns the sub-account to the person who needs it. But how does the master account view the usage of each sub-account? I'll take a brief introduction to this next.

First, the master account login ea.windowsazure.cn, on the report page---Click Download usage, tick the account name

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/8B/CD/ Wkiol1hzugjjty-eaadgsiq58va991.png "" 529 "height=" 484 "/>

Select a date range and click request usage data

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/8B/CD/ Wkiol1hzugmczvtfaadn8to8gr8943.png "" 549 "height=" 484 "/>

Click to download

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/8B/D1/ Wkiom1hzugqcdmp9aabbhsveg7w686.png "644" height= "/>"

Save the file to your computer

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M02/8B/CD/ Wkiol1hzugzbx-gtaajtrgyb3eo564.png "" 632 "height=" 484 "/>

The downloaded CSV file is all Azure usage data for all users and is not easily accessible

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/8B/D1/wKiom1hZUG_ Amka9aanvxbttfpa993.png "" 644 "height=" 349 "/>

We need to do further processing of this CSV file through a pivot table.

1. To download the bill, first delete the 1, 2 lines

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/8B/CD/ Wkiol1hzuhdc8rkwaadhzmfwx0k645.png "" 644 "height=" 123 "/>

1. Then select All, choose Insert (INSERT, select the first, Pivot table) directly Click OK, you can

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/8B/CD/ Wkiol1hzuhxbmcaoaaqpw87myss600.png "" 644 "height=" 424 "/>

650) this.width=650; "title=" clip_image006 "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" clip_image006 "src=" http://s3.51cto.com/wyfs02/M02/8B/D1/ Wkiom1hzuhecib3xaaek1tbkoo0117.jpg "" 590 "height=" 484 "/>

4. Use the following pivot Table filter, column (account name account owner, subscription GUID in order) Value Please select sum (the last picture is molded)

650) this.width=650; "title=" clip_image008 "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" clip_image008 "src=" http://s3.51cto.com/wyfs02/M00/8B/D1/ Wkiom1hzuhjyazptaacp6uzj-6a845.jpg "" 387 "height=" 484 "/>

650) this.width=650; "title=" clip_image010 "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" clip_image010 "src=" http://s3.51cto.com/wyfs02/M00/8B/D1/ Wkiom1hzuhnigtn5aad0ix6nxci318.jpg "" 644 "height=" 475 "/>

650) this.width=650; "title=" clip_image012 "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" clip_image012 "src=" http://s3.51cto.com/wyfs02/M00/8B/CE/ Wkiol1hzuhryog9uaab3adzp-vk758.jpg "" 434 "height=" 484 "/>

Finally form the following form,

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; border-bottom:0px; border-left:0px; Display:inline "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M01/8B/CE/ Wkiol1hzuhvjpxaxaag51l7yins800.png "" 644 "height=" 429 "/>

This makes it very easy to see the azure consumption (bill) for each sub-account and each subscription underneath it.

Azure EA Viewing the use of sub-accounts