→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
stimpy_555
Engaged Sweeper III
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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