Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssetCustom.Model, tblAssetCustom.Manufacturer, tblAssetCustom.Location, tblAssets.IPAddress, tblAssets.Firstseen From tblAssetCustom Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType Where tblAssets.Firstseen > GetDate() - 7 And tblAssetCustom.State = 1 And tblAssets.Assettype <> -1 And tblAssets.Assettype <> 66 Order By tblAssets.AssetName
Explore the full platform, free for 14 days.
No credit card required.