→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎03-07-2017 07:05 PM
‎03-08-2017 03:17 PM
‎03-07-2017 07:59 PM
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblOperatingsystem.Caption As OS,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Model,
Case When tblAssetCustom.Manufacturer Like '%vmware%' Then 'Virtual'
When tblAssetCustom.Manufacturer Like '%microsoft%' Then 'Virtual'
Else 'Physical' End As Type,
tblAssetCustom.Serialnumber,
tblAssets.IPAddress,
tblAssets.Processor,
tblProcessor.NumberOfCores As [#Physical Cores],
tblProcessor.NumberOfLogicalProcessors As [#Logical Cores],
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now