So close to providing IPAM capabilities

[JonG]

Aware that Lansweeper only records info on devices that return information, but sure it would not take much to provide IP Address management capabilities offered by third parties. Unscannable devices could be added manually and the ability to track and record device history is already built into the product.

Considering using something like the ipnetwork utility over ar codeplex (http://ipnetwork.codeplex.com/) to add CIDR notation to a custom field on each assett which may provide some way of graphing subnet usage and spare capacity as a start off.

Is IPAM capability on the product roadmap ?

Thanks

Jon

[Esben_D]

FYI here is a query to calculate the number of IP addresses in a range if you have the start + end of the IP range

Select IprangeID,
(Cast(PARSENAME(ipend, 4) as bigint) - Cast(PARSENAME(Ipstart, 4) as bigint)) * 16777216 + (Cast(PARSENAME(ipend, 3) as bigint) - Cast(PARSENAME(Ipstart, 3) as bigint)) * 65536 + (Cast(PARSENAME(ipend, 2) as bigint) - Cast(PARSENAME(Ipstart, 2) as bigint)) * 256 + (Cast(PARSENAME(ipend, 1) as bigint) - Cast(PARSENAME(Ipstart, 1) as bigint)) * 1 as size,
Enabled,
Servername
from tsysIPScanRanges

It might help with this setup

[Hendrik_VE]

Hope this works..

[rader]

Hendrik.VE wrote:
Hope this works..

Thank you.

It didn't work quite right until I saw the IP range you had in the tsysIPLocations.Realstart criteria and once I modified that, it worked like a charm.

[Hendrik_VE]

Years went by, pretty sure the wish list must have exploded by now

The question regarding IPAM capabilities popped up also in my company. We manage about 1000 subnets (industrial networks, so a lot of segmentation/segregation). So how can we keep track of all these mostly small (eg. /26, /27, /28) subnets?
We tried SolarWinds IPAM, but after some testing we said, let's think out of the box, so we used Lansweeper .

Hence, I imported all our subnets under Asset Groups/IP Address Range Locations. Because we don't use the deployment feature (we have other tools for that), we inserted the subnet (CIDR notation) under Package Share en Subnet Responsible (contact) under Share Username.
Additionally, I've added for every subnet IP Range Scanning with the corresponding start IP address, and the Subnet Description under Scanning Targets. Of course, 'Save pinged IP' is activated.

Lastly, I've created a custom report that correlates all this information together:

Select Top 1000000 tsysIPLocations.IPLocation,
  tsysIPLocations.PackageShare As Subnet,
  tsysIPLocations.Realstart As StartIP,
  tsysIPLocations.Realend As EndIP,
  tsysIPLocations.ShareUsername As Contact,
  Count(tblAssets.AssetID) As [used IP],
  Case
    When Right(tsysIPLocations.PackageShare, 2) = 24 Then 254
    When Right(tsysIPLocations.PackageShare, 2) = 25 Then 126
    When Right(tsysIPLocations.PackageShare, 2) = 26 Then 62
    When Right(tsysIPLocations.PackageShare, 2) = 27 Then 30
    When Right(tsysIPLocations.PackageShare, 2) = 28 Then 14
    Else 6
  End As [Max IPs],
  tsysIPScanRanges.Description As [Subnet Description]
From tsysIPLocations
  Left Join tblAssets On tsysIPLocations.LocationID = tblAssets.LocationID
  Left Join tsysIPScanRanges On tsysIPLocations.Realstart =
    tsysIPScanRanges.Ipstart
Where tsysIPLocations.Realstart Like '%10.99.%'
Group By tsysIPLocations.IPLocation,
  tsysIPLocations.PackageShare,
  tsysIPLocations.Realstart,
  tsysIPLocations.Realend,
  tsysIPLocations.ShareUsername,
  tsysIPScanRanges.Description
Order By StartIP

IPLocation	    Subnet           StartIP	    EndIP	        Contact	 usedIP Max IPs	 Subnet Description
AAN1-B520-19	10.99.137.224/28 10.99.137.225	10.99.137.238	Barry E	 1      14	     SA SERVER Network
AAN1-B520-40	10.99.136.0/26	 10.99.136.1	10.99.136.62	Freddy J 7      62	     PIMS Test Servers
AAN1-B520-39	10.99.131.0/26	 10.99.131.1	10.99.131.62	Bico VDS 51     62	     PIMS Production Servers

You can easily click on the subnet and query the underlying hosts.
In a next step, I'll be exporting this data to Power BI to get a visual representation of the usage of our subnets.

[rader]

Hence, I imported all our subnets under Asset Groups/IP Address Range Locations. Because we don't use the deployment feature (we have other tools for that), we inserted the subnet (CIDR notation) under Package Share en Subnet Responsible (contact) under Share Username.
Additionally, I've added for every subnet IP Range Scanning with the corresponding start IP address, and the Subnet Description under Scanning Targets. Of course, 'Save pinged IP' is activated.

Could you share the screenshots of what your describing above? I'd like to follow it, but got lost in the mire that is the configuration hell.

Thank you.

[Esben_D]

I've double checked to make sure that this is still on the wish list. I've also double checked that this topic is linked to the existing feature request.

[milpo2717]

I would like to ensure this feature is kept on the wish list. We are in dire need of IPAM and loathe having to consider solarwinds or InfoBlox (another tool).

[Hemoco]

We have added your feature request to our customer wish list, but this will most likely not be implemented anytime soon. Our focus is on developing a help desk.

[JonG]

Do not think automatically adding IPs that have no open protocols is a good idea. Not sure how much work it would be but to automatically track IP usage (and spare capacity) in each range created which can be pulled through to reports would be a good middle ground. There are ways of identifying the maximum and minimum IP (or CIDR notation) using the IP and subnet mask which is probably all that would be needed to make this possible. It could also be used to identify misconfigured devices that have been allocated the wrong subnet mask which can create network issues if not corrected.

Jon