Does anyone has an explanation about how to use SWQL/SQL query on creating alerts? i want to create a node alert by SQL/SWQL querys. is it possible?
Hi I am always getting different result as compare to SWQL Query and Web Report Writer. Mentioned is Report of Average Availability LAST MONTH. SWQL Result: SELECT concat(round(avg(Availability), 2), ' %' ) as supernet FROM Orion.ResponseTime rt where monthdiff(datetime,getdate())=1 and rt.Node.CustomProperties.SLA_LTE…
I am using a powershell script to create an automation for node creation. I have found that when the discovery credential is WMI none of the interfaces are added, which is fine. However; when the discovery credential is SNMP all of the interfaces are added so I added the following code to remove the interfaces from…
I get the following error after logging into SWQL Studio (v3.1.0.343, but I also had it in the previous version, v2.6.0.238-beta. I had hoped the upgrade would fix it.) I can open and run saved queries, but I am unable to see the table listing in the database. The log looks like this followed by a long xml formatted text.…
Problem: My access points that are down don't want to appear in the node down KPI widget. The query that I have used for the node-down is this one: select count(status) as countnodes from orion.nodes where (status =2) I made another widget just to show the Access points that are down: select count(status) as countnodes…
I'm using this in the where statement feel like there should be another variable? WHERE s.Polling.Node.Caption LIKE '%${SEARCH_STRING}%' OR s.Name LIKE '%${SEARCH_STRING}%'
Having trouble adding a Node to NCM with Python 3.8. I'm able to add a new node and add it to pollers via the API. I get an error when I add it to NCM using invoke on Cirrus.Nodes. AddNodeToNCM. I'm on OrionPlatform 2017.3.5 SP5, NPM 12.2 NCM 7.7 Based on the below post, it looks like I'm following the correct process.…
hi Everyone, i have this query which is suppose to provide the nodes which has percentage utilization above 75% for the last month, this query is run on a monthly basis, it was working previously but now the query has started to time out for some reason. SELECT DISTINCT ( InterfaceID) AS Nuddles,NodeID FROM…
Dear , Need to Run Grafana in the Dockerized environment , Need to integrate Solarwinds Datasoure in the Docker file , steps mentioned as below , https://github.com/etichy/grafana-swis-datasource Can you share me some reference of the docker file for the above request. Thanks Basil
Greetings, we would like to know if Orion can be integrated through an API or another method, with the Spectrum monitoring tool. The idea is to be able to send the alerts generated by Orion to Spectrum
It looks like you're new here. Sign in or register to get started.