Working smart not hard. (help needed)

Working on Cisco and HP equipment

I was wondering if you guys know of any python script that might solve the current dilemma that I'm facing:

^{cue super long story in which the network admin ends up doing all the work ...}

So basically i need to create access lists on each of the ports of 600+ switches for the devices that are currently connected there (could be just a PC or a Phone and pc or a printer)

So, here is my process right now:

• Sh mac-address table | inc Fa0/
  • [I get the entire list of mac addresses that i learn from the ports]
• Cross reference that with a list that an onsite tech gathered a few weeks ago
  • [+50% of the information is Incorrect]
• Start pinging the entire segment from the switch 1 IP at the time
  • [This gets better by the minute]
• once the ARP table has been populated
• cross reference the IP and mac address to find the port where the access list will be created
• create the access list
• apply the access list via CLI on the switch

So far this has taken me over 2 hours per switch and i feel that 600 switches it's going to drive me nutz (deez nuts)

If somebody has gone through this, how did you solve it? and if so, where do i send a r/RandomActofpizza?

​

Thanks!

• ​