Send netdisco-users mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:

   1. Netdisco Help (Polimeni, Timothy)
   2. Re: Netdisco Help (Oliver Gorwits)
   3. Re: Special Report needed aka "IP-Inventory with extra
      columns" (Sebastian R?sch)
   4. Netdisco Help (Tim Polimeni)
--- Begin Message ---
Hello,
                I just recently installed netdisco and when adding a device in 
it creates a job however the job just sits in a queued status anything you can 
assist me with in resolving or walk me thru what you may need?

Thanks,
Tim Polimeni

Network Engineer
15 Summit Park drive
Pittsburgh Pa 15275
Mobile - 412-439-9460
Desk - 412-747-6488
Email - [email protected]


--- End Message ---
--- Begin Message ---
Hi Tim,

Did you start netdisco-daemon?

https://metacpan.org/pod/App::Netdisco

regards,
oliver.

On 2016-08-04 00:07, Polimeni, Timothy wrote:
Hello,

 I just recently installed netdisco and when adding a device in it
creates a job however the job just sits in a queued status anything
you can assist me with in resolving or walk me thru what you may need?


Thanks,

Tim Polimeni

Network Engineer

15 Summit Park drive

Pittsburgh Pa 15275

Mobile - 412-439-9460

Desk - 412-747-6488

Email - [email protected]


------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. http://sdm.link/zohodev2dev

_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users



--- End Message ---
--- Begin Message ---
Well, I tried to extend my query, but I was not able to filter for the most 
recent entry...


With this query I get all the nodes from the network, that seems to work:

bin/netdisco-do psql -e "COPY (SELECT 
node.mac,node.switch,node.port,node.time_first,node.time_last,node_ip.ip,node_ip.dns
 FROM node INNER JOIN node_ip ON node.mac = node_ip.mac WHERE node_ip.ip 
<<'10.0.0.0/24') TO STDOUT WITH CSV HEADER"


But if I look in the result, I see multiple entries per node for every 
timestamp, that was recorded.... So I have up to 15 result, regarding on the 
device, this node has appeared. I would like to get only the latest, most 
current timestamp.


I additonally tried this, but there not all nodes are listed then...... Don´t 
know why, maybe an error with my logic... Any ideas?

bin/netdisco-do psql -e "COPY (SELECT 
node.mac,node.switch,node.port,node.time_first,node.time_last,node_ip.ip,node_ip.dns
 FROM node INNER JOIN node_ip ON node.mac = node_ip.mac WHERE node_ip.ip 
<<'10.0.0.0/24' and node_ip.time_last = (SELECT MAX(node_ip.time_last) FROM 
node_ip)) TO STDOUT WITH CSV HEADER"


Best Regards
Sebastian


Von: Sebastian Rösch
Gesendet: Mittwoch, 13. Juli 2016 16:03
An: [email protected]
Betreff: Special Report needed aka "IP-Inventory with extra columns"

Hi all,

I´ve got a little problem....I need a report from netdisco, which is not 
available so far. If the "Ip Inventory" Report would be extend for the columns 
device and port, that would exactly meet my requirements very well. But I don´t 
know how to do that....

As I was not able to get the query working in the webinterface I tried to 
execute a query in the shell.... I was trying to combine the following select 
statement with a join. So I started with executing them for their own. But the 
select doesn´t work, the join statement works, but I would like to limit the 
output of it to nodes from a specific subnet.... I thought this could be done 
in a way like described here: 
http://stackoverflow.com/questions/12970187/nested-select-statement-with-left-join


bin/netdisco-do psql -e "COPY (SELECT * FROM node_ip WHERE node_ip.ip LIKE 
'%10.200.%') TO STDOUT WITH CSV HEADER"

bin/netdisco-do psql -e "COPY (SELECT * FROM node INNER JOIN node_ip ON 
node.mac = node_ip.mac) TO STDOUT WITH CSV HEADER"


Any ideas how I can get this working? Of course I would prefer to get it 
running as a report or the best way would be to modify the IP Inventory tool....


Regards,
Sebastian

--- End Message ---
--- Begin Message ---
Hi All,
   I am looking for some help on NetDisco. A few things. Here I am having
issues with ipv6 subnets being pulled in by netdisco. I have a vlan 900
with a ipv4/24 and ipv6 with a :64. The vlans are not showing the IPV6
space.

Also
I would like to know is there a way to stop netdisco from discovering some
subnets? For example I wont want netdisco to discover 10.8 or 10.17 space
on my private network is there a way in the deployment config to block this?

Next I wanted to add the rancid plugin is it as simple as copying the
rancid script into the deployment config and renaming the groups on which I
want them to be?

In Rancid I have UEN UES MetroE for my different types.

--- End Message ---
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. http://sdm.link/zohodev2dev
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to