[Netdisco] Mac addresses on "IP Inventory" report?

[Andreas Falk]

Hi,

Is there some way to get a mac-address report on a vlan or per CIDR like
the IP inventory report?

--
Regards Falk

[Clements, James]

+1 for that suggestion!

We were expecting to have to write a custom report for it, but if last seen mac address and date it was seen could be added into the standard IP inventory report, that would be even better.

Cheers,

James.

From: Andreas Falk [mailto:***@miralin.se]
Sent: 23 September 2014 14:19
To: netdisco-***@lists.sourceforge.net
Subject: [Netdisco] Mac addresses on "IP Inventory" report?

Hi,

Is there some way to get a mac-address report on a vlan or per CIDR like the IP inventory report?

[Cardinal-Richards, Emma]

I've written a custom report for this (shown below) but as you can imagine, loading a whole /16 makes netdisco a bit grumpy (well at least on my little dev machine) so it would be great if we could have it as an extra field on the IP Inventory report page. If you have a smaller range this report might work fine though.

label: 'IP inventory of x.x.x.x/16'
columns:
- {ip: 'IP Address'}
- {dns: 'DNS'}
- {mac: 'MAC Address'}
- {time_last: 'Time last seen'}
query: |
SELECT DISTINCT ON (ip) ip, dns, mac, time_last
FROM node_ip
WHERE ip << inet 'x.x.x.x/16'
ORDER BY inet(ip), time_last desc

Cheers,
Emma

-----Original Message-----
Sent: 25 September 2014 10:42
Subject: Re: [Netdisco] Mac addresses on "IP Inventory" report?
+1 for that suggestion!
We were expecting to have to write a custom report for it, but if last seen
mac address and date it was seen could be added into the standard IP
inventory report, that would be even better.
Cheers,
James.
Sent: 23 September 2014 14:19
Subject: [Netdisco] Mac addresses on "IP Inventory" report?
Hi,
Is there some way to get a mac-address report on a vlan or per CIDR like the
IP inventory report

[Falk]

Hi,

Thanks for the share.
This will help us when we continue our inventory of mac addresses before
rolling out dot1x on switches.

Going to try this out @ work tomorrow..

--
Regards Falk

2014-10-01 16:52 GMT+02:00 Cardinal-Richards, Emma <

Post by Cardinal-Richards, Emma
I've written a custom report for this (shown below) but as you can
imagine, loading a whole /16 makes netdisco a bit grumpy (well at least on
my little dev machine) so it would be great if we could have it as an extra
field on the IP Inventory report page. If you have a smaller range this
report might work fine though.
label: 'IP inventory of x.x.x.x/16'
- {ip: 'IP Address'}
- {dns: 'DNS'}
- {mac: 'MAC Address'}
- {time_last: 'Time last seen'}
query: |
SELECT DISTINCT ON (ip) ip, dns, mac, time_last
FROM node_ip
WHERE ip << inet 'x.x.x.x/16'
ORDER BY inet(ip), time_last desc
Cheers,
Emma

[Deshong, Kenneth]

I’m using Netdisco release 2.029007 and out of curiosity I ran the IP Inventory report but I’m getting less than optimal results. Maybe something isn’t set correctly on my server.

I’m running it against a /24 network which has about 150 active clients and has a DHCP lease time of 24 hours. When I run the report and pick last 7 days, my report only comes back with 33 entries. Shouldn’t it come back with every client that has been active in the past 7 days?


Ken DeShong
Network Engineer
USF Health Information Systems


Amazing Things Happen When You Connect the Unconnected

 
 
 

From: Falk [mailto:***@mockel.se]
Sent: Thursday, October 02, 2014 1:13 PM
To: netdisco-***@lists.sourceforge.net
Subject: Re: [Netdisco] Mac addresses on "IP Inventory" report?

Hi,

Thanks for the share. 
This will help us when we continue our inventory of mac addresses before rolling out dot1x on switches.

Going to try this out @ work tomorrow..
--
Regards Falk

2014-10-01 16:52 GMT+02:00 Cardinal-Richards, Emma <e.cardinal-***@ucl.ac.uk>:
I've written a custom report for this (shown below) but as you can imagine, loading a whole /16 makes netdisco a bit grumpy (well at least on my little dev machine) so it would be great if we could have it as an extra field on the IP Inventory report page.  If you have a smaller range this report might work fine though.

label: 'IP inventory of x.x.x.x/16'
    columns:
       - {ip: 'IP Address'}
       - {dns: 'DNS'}
       - {mac: 'MAC Address'}
       - {time_last: 'Time last seen'}
    query: |
      SELECT DISTINCT ON (ip) ip, dns, mac, time_last
      FROM node_ip
      WHERE ip << inet 'x.x.x.x/16'
     

[Oliver Gorwits]

Hi Ken,

Please start a new thread in future, the previous emails were for a
different question altogether.

For your question, please could you find an IP you're expecting to see,
and turn on archive data, and see what date Netdisco last saw the node?
It's best to start troubleshooting with something you expect to see,
then to dig to find out why it's not shown.

BTW, yes, the report looks at the last time the node was seen, and
checks it's between the start/end dates in the query.

regards,
oliver.

Post by Deshong, Kenneth
I’m using Netdisco release 2.029007 and out of curiosity I ran the IP
Inventory report but I’m getting less than optimal results. Maybe
something isn’t set correctly on my server.
I’m running it against a /24 network which has about 150 active
clients and has a DHCP lease time of 24 hours. When I run the report
and pick last 7 days, my report only comes back with 33 entries.
Shouldn’t it come back with every client that has been active in the
past 7 days?
Ken DeShong
Network Engineer
USF Health Information Systems
Amazing Things Happen When You Connect the Unconnected
 
 
 
Sent: Thursday, October 02, 2014 1:13 PM
Subject: Re: [Netdisco] Mac addresses on "IP Inventory" report?
Hi,
Thanks for the share. 
This will help us when we continue our inventory of mac addresses
before rolling out dot1x on switches.
--
Regards Falk
2014-10-01 16:52 GMT+02:00 Cardinal-Richards, Emma
I've written a custom report for this (shown below) but as you can
imagine, loading a whole /16 makes netdisco a bit grumpy (well at
least on my little dev machine) so it would be great if we could have
it as an extra field on the IP Inventory report page.  If you have a
smaller range this report might work fine though.
label: 'IP inventory of x.x.x.x/16'
       - {ip: 'IP Address'}
       - {dns: 'DNS'}
       - {mac: 'MAC Address'}
       - {time_last: 'Time last seen'}
    query: |
      SELECT DISTINCT ON (ip) ip, dns, mac, time_last
      FROM node_ip
      WHERE ip << inet 'x.x.x.x/16'
      ORDER BY inet(ip), time_last desc
Cheers,
Emma
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS
Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Netdisco mailing list
https://lists.sourceforge.net/lists/listinfo/netdisco-users