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. Export all hosts connected via SQL Link Excel (Muris)
--- Begin Message ---
Hello,
I have been trying to get an export out of netdisco via SQL using Excel to
hook into the Postgresql database. This particular export grabs all hosts
connected and which switchport etc. I ran it and seems to be working okay,
but can anyone advise if i have missed something ?
Also i do run SSH collector for devices where i need to get arp tables to
populate netdisco, however these dont seem to have entries with this
command that i am running.. if anyone can make some suggestions or
improvements it would be appreciated.. as im looking to capture all hosts
and what port they are connected.
Export All hosts and show which switch connected
NetBios Name
DNS Entry
Host IP
Host Mac
Port on Switch
Switch or WLC name
Switch Model
Switch Location
First Seen Host IP
Last Seen Host IP
First Seen Host MAC
Last Seen Host Mac
SELECT
node_nbt.nbname,
node_ip.dns,
node_ip.ip,
node.mac,
node.port,
device.name,
device.model,
device.location,
node_ip.time_first,
node_ip.time_last,
node.time_first,
node.time_last
FROM
node
LEFT JOIN node_ip ON node.mac = node_ip.mac
LEFT JOIN device ON node.switch = device.ip
INNER JOIN node_nbt ON node_ip.mac = node_nbt.mac
WHERE
node.active = 't'
ORDER BY
node.port,
node_ip.time_last
--- End Message ---
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
