Discover every Hyper-V virtual guest machine in your environment and report on detailed information about these machines. Retrieved details such as the memory assigned to the guest machine, the enabled state and health state. Alongside information about the guest machine, this overview also shows the host of the Hyper-V guest. This gives you a complete overview of each Hyper-V guest and the host it is running on. Since a user who has access to the Hyper-V manager can create and delete as many Hyper-V guests as they seem fit, having an updated and accurate information of all the Hyper-V guests can be very difficult without an automated way of discovering exactly what the host machines have running on them.
Hyper-V Virtual Guest Machines Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblHyperVGuest.Name As Guest,
tblHyperVGuest.Memory,
tblHyperVGuest.Enabledstate,
tblHyperVGuest.Healthstate,
tblHyperVGuest.Lastchanged,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblHyperVGuest On tblAssets.AssetID = tblHyperVGuest.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Order By tblAssets.AssetName
