(This picture was created with Lexica AI picture generator.)
Executive Summary:
Currently this article is about trial and error, consider this article an example of coding possibilities with ChatGPT. When I find a solution to my, “Current Problem Statement,” I will edit this article, or post again.
Request for comment:
I am very open to kind suggestion on this blogpost. I am feeling my way around to do things in a better, streamlined way. Please let me know if you have suggestions or information that can help with my coding efforts.
Brief background:
I have my CCNP and am hopeful to have the CWNE soon. At this point in my career I do not have a background in coding- at all. Yet, this is necessary and imperative for Wi-Fi cloud based networks. The dashboards are good, but they are not the Airwave type of report generating platforms. I’m looking for more of a global view for issues and problems.
For instance, is this a problem for the user on a floor, or does the floor have
issues, and it’s not being reported?
I have gone through basic Python tutorials. I have gone to GitHub to look at code, and although I can get a general understanding, I do not understand enough to effectively change the code for more specific answers. Using the Meraki Developer site to look at the GET statements is imperative.
Current Problem Statement:
GitHub has code to pull you your networks and do a month capture of the unique mac addresses across all of your networks in an organization. I want to be able to break that information into Networks/Buildings to get more granular information. Specifically, I want a user count per building, and dump that into an excel report with specific time frames.
I posted a blog on how to download and run a Meraki Health Script on August 1. Start there if you need more information before diving in this blog post.
After joining ChatGPT, I asked it to create for me Meraki Python code. It did.
My request to “Prompt for the API key. Pull all the Networks, and do a user count per network for a specified time period and dump the information to an excel spreadsheet,” produced some impressive code, but it did not work. It prompted for my API key, and then I received a 404 error.
I decided to modify my questions in an attempt to ask something more simple to find something that could work.
I copied and pasted the code to my choice of my code editor of choice, Microsoft Visual Studio.
I ran the code from Windows Power Shell.
-I’m getting somewhere.
When I chose a network of only 2 APs, I received the data.
When I chose a network of 98 APs, I received the data for 2.
The code I have from GitHub was my inspiration to use that code and modify or work with ChatGPT to get the wanted user count for network per a specific time period. Within that code, they have coding that works with rate limits. I have no doubt I am dealing with rate limits at some level.
-Note, since I wrote this, I have been able to push forward with code, using the basics of my information here: jadexing/Merakicode: Code for Meraki Wi-Fi (github.com).
I have many code bits that are pretty helpful, like a spreadsheet of you Meraki Wi-Fi models per network.
I have new challenges I would like code/ChatGPT to help me find issues faster. Stay turned for more/helpful good code.