Hardware Inventory Report

[stimpy_555]

Hi,

I was wondering if there is a basic report that will give me all hadware / network inventory scanned by LanSweeper. I have found that the All Servers report does not show VMWare Server Hosts and other server assets that are not Domain Joined assets.

Any assistance would be appreciated.

Thanks

[Hemoco · Accepted solution]

Try something like this:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tblAssetCustom.State = 1 And tblAssetCustom.Model Not Like '%virtual%'
And tblAssets.Assettype = -1 And tblComputersystem.Domainrole > 1) Or
(tsysAssetTypes.AssetTypename = 'linux' And tblAssetCustom.Manufacturer Not
Like '%vmware%' And tblAssetCustom.State = 1 And tblAssetCustom.Model Not Like
'%virtual%') Or
(tsysAssetTypes.AssetTypename = 'xen server' And
tblAssetCustom.Manufacturer Not Like '%vmware%' And tblAssetCustom.State = 1
And tblAssetCustom.Model Not Like '%virtual%')
Or
(tsysAssetTypes.AssetTypename like '%vmware%' And tblAssetCustom.State = 1)
Order By tblAssets.IPAddress