I've tried to create a python script to delete a thin AP using SWQL/SWIS. From my script: query = "SELECT TOP 5\ IPAddress,Name,\ ControllerName,\ DisplayName,\ Uri\ FROM Orion.Packages.Wireless.AccessPoints\ WHERE IPAddress = '"+thinap_ip+"' and Name = '"+thinap_name+"'" results = swis.query(query) for row in…
Hey everyone, Trying to create a report for a selected types of nodes where it will show count of interface with status against each device Please optimize the below query select n.nodeid, n.Caption as NodeName, i.InterfaceName, i.Status from orion.nodes n inner join orion.npm.interfaces i on n.nodeid = i.nodeid where…
Can you link to a table outside of the Orion schema using SWQL
I'm trying to create a query to show nodes that have been down for greater than 30 days - Found this old query in a post by @timDanner Current Query in SWQL: SELECT NodeID, MAX(Availability) AS MaxAvailability FROM Orion.ResponseTime WHERE DateTime > ADDDAY(-30, GETUTCDATE()) GROUP BY NodeID HAVING MAX(Availability) = 0…
Hello, I'm building a KPI widget to keep an eye on the response time of a node, and I need it to display some text based on the current value. i.e.: If the response time is lower than 300ms it'll display the word OK and if higher than 300ms it'll display NOT OK The below query retrieves the value but not sure how to…
Hey Everyone, I have to add snmp-server chassis-id to a few hundred device configs where the chassis-id = hostname. I am familiar with python, but really have zero experience scripting thru Solarwinds. I have seen on other threads you can pass values from the node to the script with ${caption} but am at a loss in doing so.…
What are the possible values that may appear in the "Critical" field of the "Orion.APM.Application" table?
I am getting familiar with SwisPowerShell. I know how to set node properties but not sure how to go about setting the NCM component to "NEVER". I need to do this on too many machines so SwisPowerShell seems like a perfect fit. Anyone?
Hi, I've been using the following Swis scripts ... CRUD.AddNode.ps1 DeployAgentViaVerb.ps1 ... to first add a node followed by deploying the agent to it. Works well but I can't find out how to "Manage as Node" through Swis. Under Global Agent Settings, "Automatically create node" is already selected but the node is still…
It seems like there's a large number of ways that Alerts and Actions in Orion can be set up where they don't actually do anything. Examples: Enabled alert config/definition with all actions disabled. Action with no ActionAssignment, Action that is only assigned to a disabled Alert config, impossible scheduling, email…
It looks like you're new here. Sign in or register to get started.