‎10-27-2016 11:18 AM
Solved! Go to Solution.
‎10-27-2016 03:59 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblMacMemory.Size As Memory,
tblMacOSInfo.SystemVersion,
tblMacOSInfo.KernelVersion,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.IPNumeric
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Left Join tblMacMemory On tblAssets.AssetID = tblMacMemory.AssetID
Where tblAssets.IPNumeric >= 192168123001 And tblAssets.IPNumeric <=
192168123254 And tblAssets.IPNumeric >= 192168123001 And
tblAssets.IPNumeric <= 192168123254 And tblAssetCustom.State = 1
‎10-28-2016 11:39 AM
tsysAssetTypes.AssetTypename = 'Apple Mac'
‎10-27-2016 03:59 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblMacMemory.Size As Memory,
tblMacOSInfo.SystemVersion,
tblMacOSInfo.KernelVersion,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.IPNumeric
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Left Join tblMacMemory On tblAssets.AssetID = tblMacMemory.AssetID
Where tblAssets.IPNumeric >= 192168123001 And tblAssets.IPNumeric <=
192168123254 And tblAssets.IPNumeric >= 192168123001 And
tblAssets.IPNumeric <= 192168123254 And tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now