Forum Discussion

Brass Contributor

May 09, 2018

Azure Virtual Machine runtime calculation

Hello All, I currently have an azure automation runbook that executes a get-azurermvm command against all the subscriptions in our tenant. This script compiles a table, that lists the vmSize and St...

azure monitor

Query Language

John Wildes

Brass Contributor

May 09, 2018

The fields I have to work with on this are

Location_s - string / region name

State_s - string / status of the vm / running or deallocated

type_s - string / hardwareprofile.vmsize (e.g. nv24, f2, etc)

timegenerated - automatically created during ingestion of the log

vmname_s - string / vmname

there are other fields, but not relevant to the query needed.

Samuel White

Copper Contributor

May 13, 2018

My organization is just now starting with Log Analytics and I've been looking at how we can use it to measure out Azure VM utilization. In particular, we'd like to check for any machines that might be very underutilized.

I started with just looking at the normal things like Processor, Memory, Disk usages. Comparing that to the hardware profile of VM might be interesting.

Maybe some other folks can share what they have done in this space?

Also, is there an easy way to get the schema of virtual machines or really any of the Log Analytics name spaces?

Thanks