‎01-22-2013 03:20 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssetCustom.Location,
tblAssetCustom.Building,
tblAssetCustom.Department
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.IPAddress Like '%.123.%' And tblAssetCustom.State = 1
Order By tblAssets.IPAddress
Solved! Go to Solution.
‎01-22-2013 08:14 PM
‎01-24-2013 09:47 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssetCustom.Location,
tblAssetCustom.Building,
tblAssetCustom.Department,
tblSNMPInfo.IfIPAddress,
tblSNMPInfo.IfMask,
tblSNMPInfo.IfType
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
Where tblAssets.IPAddress Like '%.123.%' And tblSNMPInfo.IfType = 6 And
tblSNMPInfo.IfType = 6 And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric
‎01-24-2013 08:31 PM
‎01-24-2013 09:02 PM
harringg wrote:
I'm refering to the Mask field in the attached screenshot. I looked in the Network tables and didn't see it. It's grabbing a value from somewhere, I'd like to add that to my reports to ensure at a glance that all the printers are properly configured, without having to click on each printer in the list.
‎01-22-2013 08:14 PM
‎01-24-2013 06:25 PM
Lansweeper wrote:
You need to use tblassets.ipnumeric to sort in sql code.
‎01-24-2013 07:07 PM
harringg wrote:
Which table is the Mask(Subnet Mask)record in for the Printers?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now