some API calls require you to pass the network ID - if you read the API calls documentation this states all the paramteres to pass to the API calls.   https://developer.cisco.com/meraki/api-v1/ ... View more

only question is where are you getting your network ID when passing to the API URL call     ... View more

you need to create a subroutine called writesql - with the following code .. then you call the subroutine with the paramters   sub WriteSQL(Location,DeviceName,UpTime,DownTime) On Error Resume Next Dim conn Set conn = createobject("Adodb.Connection") Dim sConnString Dim SqlStatement sConnString = "Provider=SQLOLEDB;Data Source=" & SQLServer01 & "; Initial Catalog=" & MerakiDB & "; Integrated Security=SSPI;" conn.Open sConnString conn.CommandTimeout = 900 SqlStatement = "INSERT INTO [dbo.TheTable] Location,DeviceName,UpTime,DownTime) VALUES (Location,DeviceName,UpTime,DownTime)" conn.Execute(SqlStatement) conn.close Set conn = Nothing If Err.Number <> 0 Then WScript.Echo "Error Writing to SQL " & Err.Description  Err.Clear End If end sub     then you call the above   For i = 0 to Ubound(apiData)  < process your data > call WriteSQL(Location,DeviceName,UpTime,DownTime) NEXT   May I ask, do you have any software development experience ... View more

you create subroutines and call these when you need perfrom some action   as an example what I do is have multiple sub routines, example below   - write to sql database - read from sql database - write to a csv/text file - read from csv/text file   hope that makes sense   ... View more

what is the StartScript, also the network ID you pass to the API call, where is thar data coming from. I have this in another database and then pass each of my network ID to the subroutine   This is what I do to pass my network ID from a database   sqlConLive=<my sql server connection> sSQL="SELECT * FROM [MerakiData].[dbo].[MerakiNetworks]" Set Connection = CreateObject("ADODB.Connection") set Recordset = CreateObject("ADODB.Recordset") Connection.Open sqlConLive Recordset.Open sSQL,Connection If Recordset.EOF Then exit sub Else Do While NOT Recordset.Eof rOffice = Recordset("Office") rNet=Recordset("NetworkID") < here I call the routine to call the API call with the rnet variable passed to my subroutine> Recordset.MoveNext Loop End If Recordset.Close Set Recordset=nothing Connection.Close Set Connection=nothing       Otherwise should work only comment is the writing to the database code... have it in a seperate sub routine and pass the required parameters - I have also added some error catching. example below   sub writeSQL(Location,DeviceName,UpTime,DownTime) On Error Resume Next Dim conn Set conn = createobject("Adodb.Connection") Dim sConnString Dim SqlStatement sConnString = "Provider=SQLOLEDB;Data Source=" & SQLServer01 & "; Initial Catalog=" & MerakiDB & "; Integrated Security=SSPI;" conn.Open sConnString conn.CommandTimeout = 900 SqlStatement = "INSERT INTO [dbo.TheTable] " & _"(Location,DeviceName,UpTime,DownTime) VALUES (Location,DeviceName,UpTime,DownTime)" conn.Execute(SqlStatement) conn.close Set conn = Nothing If Err.Number <> 0 Then   WScript.Echo "Error Writing to SQL " & Err.Description  Err.Clear End If End Sub     ... View more

This is some example code I have written in vbscript   I have all my network ID's in a database so when I run my API I pass this network ID to the subroutine.   xAPIKey is my API key defined at the start.    I check the HTTP status is 200 so I know the URL was successfull.   After the data is put into an array, I parse this array and to extract the data I want and finally I call the routine to write to the SQL database.   If I wanted to write to a CSV file, I would call a routine to write to a text file as CSV format. Obviously there is more code to what is actually done with parsing the data     Sub DotheWork (sNet)   sUrl = "https://api.meraki.com/api/v1/networks/" & sNet & "/clients?timespan=300&recentDeviceConnections[]=Wireless&statuses[]=Online&perPage=2000"   set http=createObject("Microsoft.XMLHTTP") http.open "GET",sUrl,false http.setRequestHeader "Content-Type","application/json" http.setRequestHeader "Accept","application/json" http.setRequestHeader "X-Cisco-Meraki-API-Key",xAPIKey http.send responseText=http.responseText If http.Status = 200 Then apiData = Split(responseText , ",") For i = 0 to Ubound(apiData)   < this is the where I parse the data to extract the information I need>   Next call WriteSQL(x,y,z) End If end sub ... View more

I will get some example code over, I run these on a windows server as a scheduled task . Obviously servers needs access to the Meraki API URL ... View more

yes all API calls ... View more

correction MR56 not MR36 ... View more

Still having issues with 30.7 on the MR56 access points so going to roll back the firmware to 30.6 to confirm the current stable firmware has performance issues ... View more

I have done this by writing multiple API calls to download the data, parse it and directly write it to a back end SQL database with a basic front end web internal website to show the data.    Most of the API calls are to have a live wireless usage for people within the company who dont have access to the dashboard. With the data in a database I also have a Power BI report that can graphs how many people are in the office over a timeframe.   I wrote all this in a simple visual script ... View more

After multiple attempts by Meraki support to flash the firmware, they have replaced the switch. ... View more

upgraded to this firmware on MR36 and users complaing of poor performance, Teams calls dropped etc   Client balance is disabled.  ... View more

As stated this is a GUI bug, I have set mine to 0/0 and although the GUI states limited to 100 mb/s, a speed test confirms I get above 100 mb/s.  My upload from my ISP is 100 mb/s but download is 1 GB/s           ... View more

Have you got client balancing enabled, we had such an issue on the MR56 where as clients (Windows 10 laptops) were constantly roaming between AP's.   We disabled client balancing and this has resolved the issue for us. ... View more

static IP and yes on dashboard online    As I say I was able to PING all 4 switches but now I cant PING 2 of them ... View more

I am signed up username is jfish_1971 ... View more

I wrote some software using API calls to collect this information, write it to a back end SQL database and a front end web site to show the information for each office and number devices conenctions.    Other details I collected was channel utilisation.   Also used Power BI to create fancy graphs. ... View more

There is a very long thread on this forum regarding ths issue.   https://community.meraki.com/t5/Wireless-LAN/Wi-Fi-Clients-being-Disassociated-due-to-quot-excess-frame-loss/m-p/196892#M26701       We experienced this issue in our head office where clients were being roamed between AP's and loosing connection, looks like Meraki have finally acknowledged the issue.   We disabled client balancing on all the AP and this issue was resolved.   Another factor is wireless drivers can also cause this issue. Intel released some new drivers to resolve this issue   The latest Intel drivers for the AX201 wireless chipset has the following fix   When connected to certain wireless APs in 802.11ac or 802.11ax mode, network connectivity loss (Windows System Event ID 5002) might occur after roaming   https://www.intel.com/content/www/us/en/download/19351/windows-10-and-windows-11-wi-fi-drivers-for-i... ... View more

The latest Intel drivers for the AX201 wireless chipset has the following fix   When connected to certain wireless APs in 802.11ac or 802.11ax mode, network connectivity loss (Windows System Event ID 5002) might occur after roaming   https://www.intel.com/content/www/us/en/download/19351/windows-10-and-windows-11-wi-fi-drivers-for-intel-wireless-adapters.html ... View more

what devices do you have Windows Mac Android etc   When you say no internet access, what symptoms do you have   Devices that can not connect to internet can you ping any external ip eg 8.8.8.8   Have you done a network capture on access point to troubleshoot  ... View more