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.
- 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 "/>
- 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