Having historic data and information of a subscription's usage records, for monitoring, comparison, or audit purposes, is essential. For this reason, we have introduced a reporting tool that helps the BSS user to view and export a legacy Azure subscription’s usage records along with the costs of the previous six billing cycles.

Accessing the Tool

To access the tool, please navigate to BSS Setup > Tools > Microsoft Cloud Services > Subscription's Usage Records.

Image RemovedImage Added

The tool runs ad-hoc and returns the usage records for a specific legacy Azure subscription at a specific billing period.

Retrieving Usage Records from a Subscription

After selecting the tool, the BSS user lands on the following page, where the tool has three parameters for the user to submit in order for the retrieval process to be initiated.

Image Added

The tool's parameters are the followingthe Subscription ID, the Previous Billing Cycles, and the Available Pricelists. 

However, as it can be seen, the only available field to be completed at first, is the Subscription ID. The other fields are locked until an ID is defined. Once the ID of the subscription is defined, the “Get Subscription Data” button needs to be clicked. This button retrieves all the available information for the provided legacy Azure subscription ID regarding its Previous Billing Cycles and Available Price-lists:

• Subscription ID: The BSS  The ID of the legacy Azure subscription for which we need to get the historic records.

• Billing Period. This will be Previous Billing Cycles: This is a drop-down where it will display the past 6 periodsdisplays the past six billing cycles. The dates represent the BSS cycles as retrieved from the subscription. However, if a subscription is relatively new, only the previous available billing cycles will be available. Its default option is the exact previous billing cycle. If for example the legacy Azure subscription are is renewed every 28th twenty eighth of the month and we run the tool on the 11/03 eleventh then the available periods will be: 28/01/2020 - 27/02/2020. 28/12/2020 - 27/01/2020, etc.. 

• Pricelist. The system will display by default the pricelist that it is related with selected renewal record but the customer will have the Available Pricelists: The BSS user has the option to change and select a different pricelist. There will be a check that a pricelist can be selected only if it includes the Azure product.

By running the tool, the system will display the list of the usage records with the following columns:

• Charge Start Date: It will be the start date of the selected period. it will be the same for all records

• Charge End Date: It will be the end date of the selected period. It will be the same for all records

• Resource Group

• Resource ID

• Resource Name

• Resource Category

• Resource Sub Category

• Region

• Consumption / Unit 

• Usage Charges

The BSS user will able to export this list in an excel file.

•  The data we will be collected from what we keep already in our database, no API calls to MS

• The values will be with not tax

Tool Notes: Tα usages είναι estimated και οχι τα actual που θα δει ο πελάτης στο τιμολόγιο.

1. Πάντα δείχνουμε τις τιμές με βάση το current ratecard (δεν υπάρχει επιλογή ιστορικού ούτε σε εμάς ούτε στην MS). Αυτό σημαίνει πως αν κάποιο resource έχει γίνει deprecated η τιμή που θα δείχνουμε θα είναι 0.

2. Τα usages έχουν γίνει round με τον αριθμό των decimals που γίνεται και η συνδρομή

3. Οι ημερομηνίες φαίνονται στο timezone και στο date format του χρήστη.

Its description is: “Εxport/Review the Azure subscription's usage records”.

Once clicked, this is the view displayed at the BSS User:

Image Removed

As it can be seen, the only available field to be completed is Subscription ID. The other fields are locked until an ID is defined.

• price-list, since the Available Pricelists field is populated with the following options:

  • No Pricelist (default option): The No Pricelist option displays the Usage Charges with no PL assigned to them. If selected, this option displays the Usage Charges with no price-list assigned to them.

  • Subscription Pricelist: The subscription's assigned price-list. If selected, this option displays the Usage Charges with the price-list that this subscription had assigned to it during the selected billing cycle.

  • Any other Pricelist found in this Organization that includes the legacy Azure product and is contained in the subscription added above.

  
  

Extra two buttons appearance after the "Get Subscription Data" action:

Image Added 

• If an ID that corresponds to an azure a legacy Azure subscription is used, the 2 dropdowns then the two drop-down menus are populated and also 2 two more buttons are displayed:

  • The Usages from BSS button: Upon clicking on it, it retrieves all the usage records found in our database.

  • Usages from MSThe Usages from MS button: Upon clicking on it, it retrieves all the usages returned by Microsoft.

The previous Billing Cycles field is populated with all 6 previous billing cycles if found. The dates represent the BSS cycles as retrieved form the subscription. If a subscription is relatively new, only the previous available billing cycles will be available. Its default option is the exact previous billing cycle.

The Available Pricelists field is populated with the following options:

• No Pricelist (default option)

• Subscription Pricelist

• Any PL found in this Organization that includes the azure legacy product that is contained in the subscription added above.

The No Pricelist option displays the Usage Charges with no PL assigned to them.

The Subscription Pricelist option displays the Usage Charges with the pricelist that this subscription had assigned to it during the selected billing cycle. Here, the following apply:

Image Removed

Image Removed

Under Subscription Pricelist, all the available PLs found in this Organization that include the azure legacy product that is contained in the subscription added above.

Image Removed

Functionality

Displaying Usage Records of a Subscription

Once the BSS user has finished populating the Subscription ID and running the “Get SubscriptionData” runs and populates the dropdowns, 2 new buttons are displayed.

The “Usages from BSS” button retrieves all the usages found in our db.

The “Usages from MS” button retrieves all the usages returned by Microsoft.

action as well as populating the Previous Billing Cycles and Available Pricelists drop-down menus, he can then choose to initialize the ad-hoc retrieval of usage records by clicking on either one of the two buttons (Usages from BSS, Usages from MS), according to the results he wishes to view; either from our BSS system or from Microsoft's system.

Image Added

Then the tool, according to the BSS user's button-choice, displays a list of the usage records with the following columns:

• Resource ID: The ID of the resource.

• Resource Name: The name of the resource.

• Resource Group: The group to which the resource belongs. Filtering is available.

• Resource Category: The category to which the resource belongs. Filtering is available.

• Resource Sub Category: The subcategory to which the resource belongs. Filtering is available.

• Consumption/Unit: The consumption of the resource. 

• Usage Charges: The usage charges of the resource.

• Charge Start Date: It is the start date of the selected period. It will be the same for all records.

• Charge End Date: It is the end date of the selected period. It will be the same for all records.

Image Removed

Different Calculations of Usage Records for a Subscription

In order to perform different calculations - based on a different PLprice- OR list or for a different billing cycle, the BSS User can make different selections in the dropdowns drop-down menus and click again either one of the following buttons, "Usages from BSS" or "Usages from MS button.".

Clearing Results of Usage Records for a Subscription

If the User wants BSS user wishes to clear the results and initiate a new search for a new subscription Subscription ID, a clear button has been added. 

Image Removed

Image Added

By clicking on it, all results regarding the previous subscription Subscription ID are lost and the process starts again by having only the Subscription ID field and the “Get Subscription Data” button available.Finally an “Export to Excel” button

Exporting Usage Records of a Subscription

After the appearance of the list of usage records, anImage Added button is available which will export the current view of the BSS User tool to a spreadsheet. This means that this action does not perform any extra retrieving of data but rather exports what is currently on the UI of the BSS User. The excel columns will be the same as the ones found in the list of the tool. So for The format of the name of the excel file is the following: "Azure Legacy Usages - Subscription ID number.xslx".

For example, if the BSS User filters the resources and only the “Virtual Machines” Category is displayed and then the export is performed, only the “Virtual Machines” Category will be exported to that spreadsheet.