All Current Clients Excluding Guest WiFi

[Grantae]

I am trying to find the best way to see all currently connected user devices (wired and corp wifi, but not guest wifi).

The organization summary shows clients over the last week but I'm not seeing a way to filter that would help other than "Online," which doesn't filter out Guest users.

Organization Overview had even less filtering options.

Going to each Network individually and looking in Network-wide Clients has the filters I need to see the currently Online and filtering by VLAN is the most helpful for me (other good filters exist though). However, I would need to do this for about 70 Networks.

Does anyone know of a better way to find this data without searching in each network individually 70 times? 

[Mloraditch]

The API is going to be your friend here:

https://developer.cisco.com/meraki/api-v1/get-network-clients/

You should be able to iterate through your networks, filter by online and then just filter out guest users in the resulting data

[Grantae]

I've been having a lot of issues getting APIs for Meraki working. I can get the URL https://api.meraki.cam/api/v1/organizations to output info when I'm logged into the Meraki portal and use that URL but when I try to run a scripted code it isn't working at all. My team doesn't normally dabble in scripts and APIs, and I don't have a lot of personal experience with them. 
Script seems to fail at 'import requests' which is the first line.

[Mloraditch]

I suggest looking at getting started https://developer.cisco.com/meraki/api-v1/getting-started/ and go from there. I find postman pretty helpful for what I need to do. You could definitely do what you need with a runner in there. Not super pretty but you would get results you could combine and then parse.

There are plenty of resources out there on the internet to learn and test with Postman or Python in a general sense.