Azure DevTest Labs: Export lab VM usage data for reporting

30. mars 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 konto

$200 i Azure-kreditter og 12 måneder med populære tjenester – gratis

Start gratis

Visual Studio

Abonnenter får opptil $1800 per år med Azure-tjenester

Aktiver nå

Nystartede bedrifter

Bli med i BizSpark-programmet, og få gratis Azure-tjenester

Les mer