Hi - need some SWQL for cpu usage above 90% all servers - thanks
Connecting swql and get the following Not certain how to correct.
Hi, I am trying to store a bearer token (obtained from a POST request to management.azure.com) for use in subsequent GET calls to the same API. I'm running into a problem though, I can successfully get the token and store it in a variable called 'access_token'. However, when I try and reference that variable from the other…
Ok, this is a fun one. I can a basic query in the web console swisquery page - select top 100 corenodeid from ncm.nodes. Not a problem. I can create and run NCM based report in the web console and open the config manager etc. I have the Admin NCM role. It is all good, UNTIL I open SWQLStudio. Then I get nothing but the…
Hi, We have created a dashbaord widget for viewing total numbers of nodes but it also includes the unmanaged nodes. We only want to see the total number of managed nodes. Could anyone please help with the SWQL query for that? The query that I have used- select count(1) as countnodes from orion.nodes where…
I'm just starting out with SWQL and Modern Dashboards. I've watched the virtual classroom videos on the topic. I wanted to make sure that I could test and learn queries on the server and then just copy them to a user defined query while making a dashboard. I suspect this should work. My observation so far is that I could…
Hi, I am new to this space and have been following the documentation and tips shared by fellow community members. I've been working on to get the monthly availability reports for the monitored devices from Solarwinds via API. On one of the posts I came across a suggestion solution with the SWQL query - which works fine on…
I'd like to understand how a SQL query would work to do a graph that would show top 5 percent interface utilization. I've figured out how to do this with the GUI but I can't quite wrap my head around how this would be done in SQL? I've done similar queries where its a singular number being summed or calculated then sorted…
Hello, I've been trying to get accurate availability information using SQL for use with the modern dashboards, but I'm running into issues with the information. I am seeing a big discrepancy in the numbers. The code I am using I pulled from this forum, but is not pulling the information I am looking for. The Code: SELECT…
i am using this URL f"{base_url}/Invoke/Orion.NPM.InterfacesCustomProperties/ModifyCustomProperty" to set custom property on a given interface on a particular node. payload = { "uri": interface_uri, "PropertyName": property_name, "propertyValue": property_value } i am pretty sure this is not the way to do it, but do any…
It looks like you're new here. Sign in or register to get started.