Kiwi Cat Tools has a great report called Report.X-Ref.Port MAC ARP. This report combines two separate jobs: Report.mac address-table and Report.arp table, and then creates a combined spread sheet that tells me what device/IP Address/MAC is plugged into a switch and its port.
We would like something similar in NCM. This tool is great for troubleshooting where an IP address is and where a MAC ID might reside. However, NCM does not have any report generation based on MAC address table, it does get ARP information however.
A sample of the report from Kiwi CatTools is below.
Device Name | Interface name | Type | Description | Duplex | Status | Speed | Security | VLAN | MAC | Last Seen | IP | HostName |
Main 2911 | GigabitEthernet110/2/0/26 | C6k 1000Mb 802.3 | | Full-duplex | down / down | Auto-speed | | 110 | D4C9.EFD7.C688 | 4/15/2017 | 172.31.25.10 | PC1.domain.name |
Main 2911 | GigabitEthernet110/2/0/27 | C6k 1000Mb 802.3 | | Full-duplex | down / down | Auto-speed | | 110 | D4C9.EFD7.C689 | 3/18/2017 | 172.31.25.11 | PC2.domain.name |
Main 2911 | GigabitEthernet110/2/0/28 | C6k 1000Mb 802.3 | | Full-duplex | down / down | Auto-speed | | 110 | D4C9.EFD7.C690 | 3/2/2017 | 172.31.25.12 | PC3.domain.name |
Main 2911 | GigabitEthernet110/2/0/29 | C6k 1000Mb 802.3 | | Full-duplex | down / down | Auto-speed | | 110 | D4C9.EFD7.C691 | 1/26/2017 | 172.31.25.13 | PC4.domain.name |
Branch 2960 | GigabitEthernet1/0/2 | C6k 1000Mb 802.3 | | Full-duplex | down / down | Auto-speed | | 10 | D4C9.EFD7.C692 | 1/5/2017 | 172.30.25.14 | PC5.domain.name |
Branch 2960 | GigabitEthernet1/0/3 | C6k 1000Mb 802.3 | | Full-duplex | down / down | Auto-speed | | 10 | D4C9.EFD7.C693 | 12/8/2016 | 172.30.25.15 | PC6.domain.name |
Branch 2960 | GigabitEthernet1/0/4 | C6k 1000Mb 802.3 | | Full-duplex | down / down | Auto-speed | | 10 | D4C9.EFD7.C694 | 11/12/2016 | 172.30.25.16 | PC7.domain.name |
