Something like this : This Script writes all sites which have AMP running in an excel file import meraki import xlwt from xlwt import Workbook import apikey api_key = apikey.Get_Api_Key("COMPANY") wb = Workbook() sheet1 = wb.add_sheet('AMP') sheet1.write(0,0,'Network') sheet1.write(0,1,'Status') row_count = 1 dashboard = meraki.DashboardAPI(api_key) my_org = dashboard.organizations.getOrganizations() for org in my_org: print(f'\nAnalyzing organization {org["name"]}:') org_id = org['id'] my_networks = dashboard.networks.getOrganizationNetworks(org_id) for my_net in my_networks: net_id=my_net["id"] try: my_sec = dashboard.malware_settings.getNetworkSecurityMalwareSettings(net_id) sheet1.write(row_count,0,my_net["name"]) sheet1.write(row_count,1,my_sec["mode"]) row_count += 1 except: print (" Site : ",my_net["name"]," not running") wb.save('AMP-Sites.xls')
... View more