Report to show VM server hosts

[daniel890]

Hi All,

I have the below SQL script which gives me all I need. The only thing it does not report back are VM host servers, Can anyone point me in the right direction?

Select Top 1000000 tblAssets.FQDN,
tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblDiskdrives.Caption As [Drive Letter],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling((tblDiskdrives.Size / 1024 / 1024) - (tblDiskdrives.Freespace / 1024 /
1024)) As UsedMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tsysOS.OSname,
tblAssets.SP,
tsysAssetTypes.AssetTypename
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 And
tblDiskdrives.DriveType = 3) Or
(tsysAssetTypes.AssetTypename Like '%vmware%' And
tsysAssetTypes.AssetTypename Like '%vmware%' And tblAssetCustom.State = 1)
Order By tblAssets.AssetName,
[Drive Letter]

[RCorbeil · Accepted solution]

I don't have any VMWare servers, but I do have some workstations. Maybe you can identify them the same way.

-- belt & suspenders: check for either field to match
tblAssetCustom.Manufacturer Like 'VMWare%'
OR tblAssetCustom.Model Like 'VMWare%'

Where actual field contents are:

Manufacturer: VMware, Inc.
Model.......: VMware Virtual Platform

I show some Microsoft VM servers on my network, too.

Manufacturer: Microsoft Corporation
Model.......: Virtual Machine