
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-22-2013 03:20 PM
When viewing an IP Locations Overview report (our printers all have a common third octet), it sorts "logically".
xx.xxx.123.1
xx.xxx.123.2
...
xx.xxx.123.9
xx.xxx.123.10
When creating a custom report to report on other items about the printers (since the IP LO report is generic in nature), it sorts like this.
xx.xxx.123.1
xx.xxx.123.10
xx.xxx.123.2
xx.xxx.123.3
...
The current code I'm using is below, is there a modification that will allow for the sorting in the first example?
Also, which table is the Mask (SubnetMask) field located?
xx.xxx.123.1
xx.xxx.123.2
...
xx.xxx.123.9
xx.xxx.123.10
When creating a custom report to report on other items about the printers (since the IP LO report is generic in nature), it sorts like this.
xx.xxx.123.1
xx.xxx.123.10
xx.xxx.123.2
xx.xxx.123.3
...
The current code I'm using is below, is there a modification that will allow for the sorting in the first example?
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
Also, which table is the Mask (SubnetMask) field located?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-22-2013 08:14 PM
You need to use tblassets.ipnumeric to sort in sql code.
6 REPLIES 6

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-24-2013 09:47 PM
Thanks. I added those fields and it gave me the information I needed. Below is the working report in case anyone is interested.
This allowed me to quickly ID which printers needed configuring and I was able to remotely update the settings.
This allowed me to quickly ID which printers needed configuring and I was able to remotely update the settings.
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-24-2013 08:31 PM
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Our apologies, this information was actually added in 5.0. The table you need is tblSNMPInfo.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-22-2013 08:14 PM
You need to use tblassets.ipnumeric to sort in sql code.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-24-2013 06:25 PM
Lansweeper wrote:
You need to use tblassets.ipnumeric to sort in sql code.
Got that working, sorted by that field and then had it hidden.
Which table is the Mask(Subnet Mask)record in for the Printers?
Thanks

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-24-2013 07:07 PM
harringg wrote:
Which table is the Mask(Subnet Mask)record in for the Printers?
This information is not currently scanned for non-Windows machines.
