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 ' \n Analyzing 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