‎01-18-2017 12:47 PM
Solved! Go to Solution.
‎01-30-2017 04:04 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysOS.OSname As OS,
tblAssetCustom.Model,
Cast(tblProcessor.AddressWidth As nvarchar) + ' bit' As [CPU Architecture],
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where (tsysOS.OSname = 'Win 7' Or tsysOS.OSname = 'Win 10') And
tblAssetCustom.Model = 'TECRA Z40-A' And tblAssetCustom.State = 1
‎01-30-2017 04:04 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysOS.OSname As OS,
tblAssetCustom.Model,
Cast(tblProcessor.AddressWidth As nvarchar) + ' bit' As [CPU Architecture],
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where (tsysOS.OSname = 'Win 7' Or tsysOS.OSname = 'Win 10') And
tblAssetCustom.Model = 'TECRA Z40-A' And tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now