Azure DevTest Labs: Export lab VM usage data for reporting

donderdag 30 maart 2017

Azure DevTest Labs now enables lab administrators to programmatically pull usage data from labs into a secondary Azure storage account. Then the data can be manipulated and visualized through other tools, like SQL Server, Azure Data Lake, and Power BI.

As a lab admin, if you want to report your labs’ usage externally—for example, to your management team, which isn't necessarily using your Azure subscription—you can use this feature. The following charts show an example of what you can get as an end result (based on your queries) by using the exported data:

Sample usage chart – VMs per month

Sample usage chart – average VM lifespan

The data is exported as two different CSV files: 

  • disks.csv, which contains information about the disks being used by the different VMs
  • virtualmachines.csv, which contains information about the virtual machines in the lab  

To get more instruction and samples about this feature, check out this blog post: How to export your Azure DevTest Labs usage data.

Gratis account

Meld u nu aan en ontvang $200 Azure-tegoed

Begin gratis

Visual Studio

Abonnees krijgen tot wel $1800 Azure-services per jaar

Activeer nu

Startups

Neem deel aan het BizSpark-programma en ontvang gratis Azure-services

Meer informatie