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)
paramiko (SSH client)
requests (REST library)
json
urllib
This script can be found in my SVN repo at [marcuscom] Log of /switchports-reports/sw-reports.py . Looking for feedback as I continue to evolve the work.