Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename As Type, tblAssets.IPAddress, tblAssets.Description, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Location, tsysIPLocations.IPLocation, tblAssets.Firstseen, tblAssets.Lastseen, tsysAssetTypes.AssetTypeIcon10 As icon From tblAssetCustom Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric Where tblAssets.Firstseen > GetDate() - 1 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.