I searched and found an old post on this but couldn't see any answer so here goes I am trying to search all nodes and update specific ones, based on machine type, with the node poller. I have looked in the nodes.pollers table but cannot see the new node poller appear here when I update one via the GUI. Any tips on where to…
I have a third party product trying to make API calls to NCM 2020.2.5 and the vendor claims that they should be able to connect to Solarwinds using this URI, but we find that our Solarwinds responds with a "404 Not Found" when attempting to reach this endpoint. Does anyone have a suggestion on another URI that perhaps this…
My team members are starting to use the SWQL studio more and more. Growing past the capabilities of the GUI and writing more SWQL code for things. Browsing the data schema we see a large number of entries that say 'Cortex...' something. The question keeps coming up - "What is Cortex"? Can someone provide an explanation or…
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?
It looks like you're new here. Sign in or register to get started.