Hi guys!
Good day!
I'm having trouble getting the "OS" and "manufacturer" of all the devices in our organization every time I use the code below.
Let me know if I need to remove or add something up.
Thanks!
# Import "meraki" to allow Meraki function calls
import meraki
# Import "datetime" to get current date and time
import datetime
# ///////// Start Definition of Script Constants ////////////////
# api_key = Unique API key generated on a per Meraki User basis
# org_id = Unique organization ID of organization you want to query
api_key = ''
org_id = ''
# Get the current list of networks from your Organization
current_networks = meraki.getnetworklist(api_key, org_id)
# Establish when "now" is, used to create the file name for output
now = datetime.datetime.now()
# Create/Name the output file with year, month, day and hour minutes
filename = now.strftime("%Y-%m-%d %H.%M") + ".csv"
# Open the file for output
f = open(filename,"w+")
# "i" will be used to increment through each "network" in the Organization
i = 0
for i in range(len(current_networks)):
# Output to console the Name and ID of the current network
print("Network Name:" + current_networks[i]['name'])
print("Network ID:" + current_networks[i]['id'])
curr_net_id = current_networks[i]['id']
curr_net_devices = meraki.getnetworkdevices(api_key,curr_net_id)
# Write to the output file the 'name' of the network and add a comma
f.write(current_networks[i]['name'])
f.write(",")
# Checks for Meraki devices on this network, if there are no devices output to file "No Devices Present"
if len(curr_net_devices) == 0:
f.write("No devices Present")
f.write("\n")
# "j" will be used to increment through each "device" on this network
j = 0
for j in range(len(curr_net_devices)):
# Output to console the serial number of the device
print ("Device Serial:" +curr_net_devices[j]['serial'])
curr_clients = meraki.getclients(api_key,curr_net_devices[j]['serial'])
# Checks for clients attached to this device, if no clients present output the name, model and serial of the
# device as well as the message "No Clients". Also catch the error that comes up in case this is a device for
# which clients are not relevant, e.g. MV camera's.
if len(curr_clients) == 0 or curr_clients[0] == "Invalid device type":
# Output to console "No Clients" message
print ("No clients")
# Output to file "name", "model", "serial" of the device as well as "No Clients" message
f.write(current_networks[i]['name'])
f.write(',')
f.write(curr_net_devices[j]['model'])
f.write(',')
f.write(curr_net_devices[j]['serial'])
f.write(",")
f.write("No Clients")
f.write("\n")
# Only list the clients if there are any.
else:
# "k" will be used to increment the number of clients on each device
k = 0
for k in range(len(curr_clients)):
# Output to console "ip" and "mac" of the client
print(curr_clients[k]['ip'],' ',curr_clients[k]['mac'],' ',curr_clients[k]['description'],' ',curr_clients[k]['vlan'],curr_clients[k]['os'])
# Output to file "name", "model", "serial" of the device as well as the "ip" and "mac"
# of the client
f.write(str(current_networks[i]['name']))
f.write(',')
f.write(str(curr_net_devices[j]['model']))
f.write(',')
f.write(str(curr_net_devices[j]['serial']))
f.write(',')
f.write(str(curr_clients[k]['description']))
f.write(',')
f.write(str(curr_clients[k]['ip']))
f.write(',')
f.write(str(curr_clients[k]['mac']))
f.write(',')
f.write(str(curr_clients[k]['vlan']))
f.write(',')
f.write(str(curr_clients[k]['os']))
f.write("\n")
# Increment "k" to move onto next client on current device
k = k + 1
# Increment "j" to move onto next device on current Network
j = j + 1
# Increment "i" to move onto next network in Organization
i = i + 1
# Close the output file
f.close()
Here's the screenshot of the error
