Re: [Netdisco] subnet usage report

[Ingen S. J. v. (ICTS) <j.v...@ut...>]

Hi Ivan,

On Thu, 2011-04-07 at 10:44 +0200, Ivan Brunello wrote:
> I was asked to produce a report on ip subnet usage.
> I would need something like:
> 
> - subnet/mask
> - size
> - usage
> 
> Since we're arpnipping device via netdisco, this would be a simple extraction.
> 
> does Netdisco provide such info in a viable way, or should I become a
> SQL guru in less than a week :-( ?

Netdisco doesn't provide this yet, but as you point out, the relevant
data for such a report is in the database.

Just one question: how would you determine "usage"? In IPv4 subnets with
regular changes in client population (eg wireless subnets), over time
all addresses will have been used. Would you determine "usage" by
counting the number of distinct IPs that have been active in the last xx
days, or by some other method?


Regards,

Jeroen van Ingen
ICT Service Centre
University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands