→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
daniel890
Engaged Sweeper
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]
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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

View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
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