I am trying to make an alert in SolarWinds that will let me know if a firewall in the meraki api is down. I didnt have an issue doing an AP is down because I can alert on wireless controller.
How am I supposed to go about this?
This is the query that works but it will only show the display name as orchestrator.
SELECT Info.Uri, Info.DisplayName
FROM Orion.Orchestrators.Info AS Info
Join Orion.Orchestrators.Devices D ON D.OrchestratorNodeID = info.NodeID
Where D.Status != 1
AND ProductType = 'appliance'
Any help would be appreciated.