Hello all - Thanks to everyone who had input on this. We were able to get the report I was looking for by joining the two tables. Here is the python code we used. Hopefully this will help others out there. Still not sure why Meraki doesn't have a canned report like this. (net_tag is something we use for upgrading our devices in groups and can be removed) import meraki import json import time timestr = time.strftime("%Y-%m-%d--%H.%M") print (timestr) org_id = '######' dashboard = meraki.DashboardAPI(suppress_logging=True) devices = dashboard.organizations.getOrganizationDevices(org_id, total_pages='all') networks = dashboard.organizations.getOrganizationNetworks(org_id, total_pages='all') for network in networks: for device in devices: if 'MX' in device['model']: dev_id = str(device['networkId']) net_id = str(network['id']) if len(network['tags']) > 0: net_tag = str(network['tags'][0]) else: net_tag = str(network['tags']) updatetime = device['configurationUpdatedAt'] date_time = updatetime.replace("T"," ") date_time = date_time.replace("Z","") date = date_time[0:10] time = date_time[12:] #print(date) for detail in device['details']: if detail['name'] == 'Running software version': if net_id == dev_id: print(device['name'] + "," + device['model'] + "," + detail['value'] + "," + device['serial'] + "," + device['mac'] + "," + net_id + "," + date + "," + time + "," + net_tag)
... View more