Hi Ben,
You can use the Device Status report to get the uplink status for every device in the org. This is a very fast call, as it returns an array of every device in the organization by default.
I could write a recursive script to iterate through every device in every network in every org... but that takes a lot longer. If there is critical information in that call that you still need, I could consider writing an additional report.
I added some extra reports and refined how the data is parsed be more dynamic with available attributes.
Make sure you the newest script (simply replace yours with this new one).
https://gist.github.com/dexterlabora/9884aa4399715df8f453ea9de63255a0
(formatting colors were applied after report)
Hello!
This has been added to the report!
Overwrite your Code.GS file with this one
https://gist.github.com/dexterlabora/9884aa4399715df8f453ea9de63255a0
Delete or Rename your settings sheet
Refresh the Sheet window to load new script
Update the new settings sheet
Hi,
I have updated a few things with this script. It now has an Org-wide and Net-wide menu. This will allow for some large reports to be more focused, such as Clients.
Script: https://gist.github.com/dexterlabora/9884aa4399715df8f453ea9de63255a0
(replace your existing script with this one)
@Riser , yes it should work but it's a bit of an old script.
You will likely need to first run the onOpen function, to load the menu the first time. It will prompt you for your Google auth to allow it to run.
Then setup a trigger to run the script every time you open the doc.
FYI,
There is a more powerful version of this app that support Dashboard API v1
https://workspace.google.com/marketplace/app/meraki_tools/11340767263
If you want the script launch the menu when you open the Google Sheet, just add a Trigger.
Do this in the Script editor section.
Select the "onOpen" function to run for the event type "On open"
You could also create macros that will run a specific function and insert the data on scheduled basis.
create a new file called macros.gs and then add this code
// example function I want to run via macro
function DeviceUplinkDetails() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('A2').activate();
callUplinkInfos();
};
Then create a new trigger for this that calls the function on a schedule.
Hope this helps!
