Azure DevTest Labs: Export lab VM usage data for reporting

30 March 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.

Free account

Get $200 in Azure credits and 12 months of popular services—free

Start free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Startups

Join the BizSpark program and get free Azure services

Learn more