
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-11-2019 01:25 PM
Hi All
we have an extensive network with several vlans, firewall and so on. We have always worked on a basis of " block all, allow what's necessary".
I'm not the person managing this so I can't see what's allowed and what not.
Is there a way to see per configured IP range when the last time a device has been scanned?
I'm not looking at the IPLocations table, those are different than what is set up in the scan servers.
Thank you
we have an extensive network with several vlans, firewall and so on. We have always worked on a basis of " block all, allow what's necessary".
I'm not the person managing this so I can't see what's allowed and what not.
Is there a way to see per configured IP range when the last time a device has been scanned?
I'm not looking at the IPLocations table, those are different than what is set up in the scan servers.
Thank you
Labels:
- Labels:
-
General Discussion
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-11-2019 02:48 PM
Yes, that's possible but it would take me a bit to figure out the SQL...
you would left join your tblassets table to tsysIPScanRanges on tblassets.ipnumeric >= tsysIPscanranges.ipstart and tblassets <= tsysipscanranges.ipend
But, the ip addresses in the tsysipcanranges are VARCHAR, so in order to compare the ranges, you have to remove the periods from the columns, then convert to NUMERIC -
that's a bit tricky for me.
but, then you could have the report, and report on max assetID grouped by tsysipscanranges.description
if that helps at all.
you would left join your tblassets table to tsysIPScanRanges on tblassets.ipnumeric >= tsysIPscanranges.ipstart and tblassets <= tsysipscanranges.ipend
But, the ip addresses in the tsysipcanranges are VARCHAR, so in order to compare the ranges, you have to remove the periods from the columns, then convert to NUMERIC -
that's a bit tricky for me.
but, then you could have the report, and report on max assetID grouped by tsysipscanranges.description
if that helps at all.
