I' m looking to create report in this form.
| Pool name | member IP | port | MAC address | SWITCH | Switchport |
| abc.somepool.com_pool | 172.17.100.100 | 80 | AA:BB:CC:11:22:33 | CH_A1-SW1 | Eth4 |
| abc.somepool.com_pool | 172.17.100.101 | 80 | AA:BB:CC:55:66:77 | CH_A2-SW2 | Eth3 |
| xyz.somepool.com_pool | 10.210.5.5 | 8080 | FF:EE:AA:33:44:55 | CH_A4-SW1 | Eth7 |
for each member of each pool IP address find MAC address, switch and switchport they connected to.
Will anyone have a suggestions on best way to go about this?
Thanks