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. Re: report - ip inventory issue (Cuttler, Brian R (HEALTH))
--- Begin Message ---
Hello NetDisco users,
I am running v2.39.31 and we are on a wild goose chase hunting for missing voip
phones.
I don't see a button in the web interface to dump the database, or search it
with the criteria I think I want and have been trying to use the postgres
interface.
I was able to dump all MAC, with switch ip and switch interface, vlan and
last-seen time stamp.
I failed to do this correctly, I'd thought
- select where vlan>'599';
Would do it, but it found me all vlans greater than "5", I ended up with
Vlan like '...' and vlan>'5';
Which at least got me things with 3 digits (our voip vlans are higher numbered
then our data network vlans).
Wrong but it was a start.
Unfortunately that also seems to have pulled the same MAC multiple times as I
seem to have pulled addresses off trunk lines and not just access ports.
I realize the vlan issue is a matter of my not knowing enough about postgres.
The second issue is an actual rancid/sql issue, I haven't been able to figure
out from the docs, the archived emails nor dumping the postgres tables where
the information on interface type is, "trunk" vs "access".
Can someone point me in the right direction?
Of course I'm open to any more reasonable approach to the problem.
Thank you,
Brian
Brian Cuttler
Network and System Administrator, ITG - Information Technology Group
Wadsworth Center, NYS Department of Health
Biggs Lab, Empire State Plaza, Albany, NY 12201
(518) 486-1697 | [email protected]
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
