Here 21 SQL queries that you can run against VMM Database and get useful information. The scripts are kindly provided by Murat Demirkiran a Senior Virtualization Expert at Denizbank in Infrastructure & System Management Group.
- VMM SQL Extravaganza01 – General VM Information
- VMM SQL Extravaganza02 – General VM Information 2
- VMM SQL Extravaganza03 – General Host Information
- VMM SQL Extravaganza04 – Host VM Count
- VMM SQL Extravaganza 05 – Empty Hosts List
- VMM SQL Extravaganza06 – VMs Placement
- VMM SQL Extravaganza 07 – VMs Storage Placement
- VMM SQL Extravaganza 08 – Stopped VMS List
- VMM SQL Extravaganza 09 – VMs with Pass-Through Disk List
- VMM SQL Extravaganza 10 – Last 10 VM Creation
- VMM SQL Extravaganza 11 – Host VM Count below 10
- VMM SQL Extravaganza 12 – Host VM Count 10 and above 10
- VMM SQL Extravaganza 13 – Host VM Average
- VMM SQL Extravaganza 15 – VMs Addition Count
- VMM SQL Extravaganza 16 – Host VMM Agent Version Details
- VMM SQL Extravaganza 17 – VMs Operating System Count
- VMM SQL Extravaganza 18 – VMs Operating System Details
- VMM SQL Extravaganza 19 – Hosts Available Memory
- VMM SQL Extravaganza 20 – Yearly created VMs
- VMM SQL Extravaganza 21 – Monthly created VMs
Cloud Administrator in Azure World 
It would be great if you could upload a sql script which lists all the vm’s and the snapshots of each vm!
I am not the author of the queries.