I've taken a first stab at creating an Cisco Prime LAN Management Solution-like switchport unused down report using APIC-EM as the main data provider. This report produces a list of switchports that are administratively up but operationally down for a specific number of days (default is 30). This makes use of the APIC-EM REST interface to obtain a list of devices and their credentials. It works with the GA version of the controller.
This is a Python script that requires the following Python modules:
sqlite3 (SQLite is the database used to cache port last-up times)