Hyper-V Report, Status, CPU, Memory, Storage Drive

[arun_aggarwal]

Hi Lansweeper Team,

I am trying to create a HyperV report where I can produce a combined report for all Hyper V clusters. I need the below mentioned columns for this report:

1. Machine Name
2. BIOS Level
3. Memory
4. Chassis
5. CPU Cores
6. Status of Machine - Off(If icon is RED) or Running(If icon in HyperV cluster is Green)
7. Storage - Drives allocation for each machine

Below is the link to an example of the similar report that is required.

http://www.serhatakinci.com/files/get-hypervreport-demo.html

Also, below is the query that we created for HyperV cluster. However, this query is missing CPU cores, status and drives allocation.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblHyperVGuest.AssetID,
tblAssets.Description,
tblComputersystem.Lastchanged,
tblBIOS.SMBIOSBIOSVersion As SMBIOSBIOSVersion1,
tblBIOS.Version,
tblBIOS.ReleaseDate,
tblBIOS.SMBIOSMajorVersion,
tblBIOS.SMBIOSMinorVersion,
tblAssets.AssetName,
TsysChassisTypes.ChassisName As Chassis,
tblHyperVGuest.Name,
tblHyperVGuest.Memory,
tblAssetCustom.State
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Left Join tblHyperVGuest On tblAssets.AssetID = tblHyperVGuest.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName

I would really appreciate if you can provide us some feedback.

Thanks,

[Susan_A · Accepted solution]

Processor information is stored in tblProcessor and drive information in tblDiskdrives, for both Hyper-V servers and their Windows guests. To check the status of the servers, you can ping them from within the report results. The status of the guests is stored in tblHyperVGuest.Enabledstate. Information on database tables and what they store can be found in our database dictionary as well.

Lansweeper doesn't specifically scan information on cluster setups though, not for now at least. It won't automatically tell you which machines are part of a cluster for instance.