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')