hi Kevin
this possibility of collecting both MAC and IP info depends on role of your switch. Normally switch is L2 device working with MAC addresses and without care of L3 (IP addresses) layer. But in case you are running your device in L3 mode, you can collect IP addresses as well. All this MAC/IP collection has to be created from two databases:
- MAC addresses from MAC address table (show mac-address inteface XXX)
- IP addresses from ARP table (it contains both MAC and IP, but without info about physical interface) of switch (show arp)(again, only in case we talking about L3-mode of switch where switch stands like default gateway for all connected devices).
now you can relate both tables with matching MAC address records in both of them.
for automate collection you can use two options:
- SNMP protocol and querying ARP and MAC address MIB tables, or
- using script which connects to switch via telnet/ssh and using commands above collects from output desired information
I can tell you the first option (SNMP) is much more easier as you are just doing queries similar to database queries.
If your switch is in L2 mode, then another option could be:
- collect MAC addresses same way like with L3 switch, and
- collect IP addresses either:
- from DHCP server leased file which assigns IPs to connected devices, or
- from your router/gateway device
