Report with current device firmware included

[Jason_42]

I have to provide a monthly report that is used by various departments in my organization. Unfortunately, I have yet to figure out how to easily get a report showing the following:

'Name / Model / Serial Number / MAC / Current Firmware Version / Date Firmware Applied'

Canned reports have some of the info for some strange reason doesn't show the current firmware version.

We have been able to pull it from API but have to manipulate it in Excel to remove duplicate entries showing past upgrades.

Along the way I have also noticed that in the GUI, on the appliance status page, the Current Version listed is different than what I can pull from the API. We are using Python in Visual Studio for this. Has anyone been able to get this to accurately work or is anyone able to point me in the right direction? It seems like an extremely large miss to not have that as an optional column on the Inventory page to export as a CSV. Especially considering it is obviously available since it is on the Appliance Status page.

I'm am very new to Python and API but this is what we have.

firmwareupgrades = dashboard.organizations.getOrganizationFirmwareUpgrades(org_id, total_pages='all')

for upgrade in firmwareupgrades:
devices = dashboard.networks.getNetworkDevices(upgrade['network']['id'])
for device in devices:
try:
if 'Completed' in upgrade['status']:
print(device['name'] + "," + device['model'] + "," + device['serial'] + "," + device['mac'] + "," + upgrade['toVersion']['shortName'] + "," + upgrade['time'])
else:
print(device['name'] + "," + device['model'] + "," + device['serial'] + "," + device['mac'] + "," + upgrade['fromVersion']['shortName'] + "," + upgrade['time'])
except Exception as e:
print(e)
continue

Any help would be greatly appreciated.

[MartinS]

Just a quick call out to the Meraki Marketplace, as there are quite a few 3rd party apps who'll do this all for you - Cisco Meraki Marketplace | Cisco Meraki

Best

Martin

[Jason_42]

Thank for your reply MartinS,

However, I find it very backwards to need a 3rd party tool for this. Isn't the point of API to allow us to do exactly these kinds of things directly without the need to invest in other tools? It seems easiest solution would be for Meraki to put a check box on the Inventory page to add firmware as a column. It's very strange to me that it isn't already there.

Thanks,

Jason