Hello Everyone, I'm confused by the Generated Properties in SWQL Studio. I need to inventory Aruba thin access points and the table 'Orion Wireless Access Points Thin' appears to have what I need (see below.) But the fields are all Generated Properties and running the SELECT TOP 1000 SWQL query produces an error. I guess…
Hi, Can someone share me the queries which are used in Modern Dashboards of Orion demo please? It's Config Summary dashboard of Orion Demo for which I am looking for the queries used for all the widgets. I am able to build All NCM nodes widget but can't get it for all. Thanks in advance.
Hi, I am using SolarWinds Orion API to create a node , discover and add interfaces. I don't know which API to use to check The CPU & Memory option in the List Resources for the node.
I tired the below query which SWQL stuidio say is valid but it return a result with a DisplayName that includes "prt".SELECT NodeId as id, DisplayName as NodeName, Status as NodeStatus FROM Orion.Nodes where (status = 2 and DisplayName not LIKE '%-PC-%') OR (status = 2 and not DisplayName not LIKE '%-PRT-%')Same result…
Just throwing this out there and wondering ... My coding skills are pretty much non-existent. I have been a hardware guy all my life and just when I think I've got a handle on something and create a new query which subsequently doesn't work I get all deflated. So off I go a Googling and a Thwacking trying to see if someone…
Hello all, I'm trying to use PowerShell to connect to the API locally so it can do actions when issues are detected. I'm able to get things working when I pass my account info into the script that won't happen due to security issues with hard coded credentials. I've tried using -Trusted to pass the current user account…
I am rather new to using the PowerShell module, and support was no help, so here I am. I have gathered a URI list in to a PowerShell array, but when I try to pass that data in to the following command: Invoke-SwisVerb $swis Orion.AlertSuppression GetAlertSuppressionState @(,$uriList,"","") The error is: Invoke-SwisVerb :…
We would like to alert on IPv4/IPv6 BGP peers but it looks like Orion's default OID doesn't include peer state for IPv6 BGP peers. I created a UnDP poller for jnxBgpM2PeerState, jnxBgpM2PeerLocalAddr, and jnxBgpM2PeerRemoteAddr but the IP addresses are returned as a Hex String. Here's a snippet of what's returned in an…
Does anyone have a script or know which tables and columns are needed to query to update the notes on an active alert? We are working on a project to update active alerts with information from our ticketing system into the notes field. From what I have gathered, here are my findings To update the alert note field I need to…
I'm trying to write a swql query that combines 4 universal Device pollers with a custom property on a node. One of the UnDP's is collated to a custom property that is attached on a Node. I want to state again the node has the custom property but one of the UnDP's has the same value as the custom property. I need to know…
It looks like you're new here. Sign in or register to get started.