
Select Top 1000000 tblAssets.AssetID, tsysAssetTypes.AssetTypeIcon10 As Icon, tblAssets.AssetName, tblOIDData.Label As [OIDLabel], tblOIDData.Data As [OIDData], tblAssets.Domain, tblAssets.IPAddress, tblAssets.Description, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Location, tsysIPLocations.IPLocation, tblAssets.Firstseen, tblAssets.Lastseen From tblAssets left Join tblOIDData On tblAssets.AssetID = tblOIDData.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric Where tsysassettypes.AssetTypename = 'NAS' And tblassetcustom.State = 1 and tblAssetCustom.Manufacturer LIKE '%QNAP%'
Explore the full platform, free for 14 days.
No credit card required.