Hi All, To identify components that have not been NOT UP for 180 days and delete them from the node level, first I have generated the following SWQL query, which produces the expected result when executed via SWQL Studio: select c.ComponentID ,c.DetailsUrl ,cst.Timestamp from orion.nodes n join orion.apm.Application a on…
Hi So I'm creating a dashboard and want to add a table that shows node that are down and how long they have been i achieved that by the below SWQL SELECT TOUPPER(SUBSTRING (n.Caption,1, CASE WHEN CHARINDEX('.',n.Caption,1) <=4 THEN LENGTH(n.Caption) ELSE (CHARINDEX('.',n.Caption,1)-1) END)) AS [IP] ,case when…
Hi Folks, Done a bit of digging on this already but was wondering if the community had any custom solutions for this problem. An estate we monitor has 3 different WAN connections in the event of outages: LoS, LTE and VSAT. All three connections are shown as up on the interfaces even when they're not passing traffic and…
Hello, We have multiple microsites each with 2-4 assets being monitored. Our structure is a larger parent group, All-Microsites. Inside All-Microsites is a child group, named for the site. We'll call the first Microsite-1 for the example, and increment as such. I have already built python that creates the group Microsite-1…
Howdy All, First time posting a question on Thwack. Hope this is the right location for this question. The following curl command used to work and return information: curl -v -k -u 'id:pw' oriinfwwwpv01.corp.pvt:17778/.../Query It returned: {"results":[{"NodeName":"CHTNWVMK-AS0001","IPAddress":"106.101.9.4"}]} We have…
I have a below query that fails: result = swis.query("SELECT HostName, IPAddress, MACAddress, ConnectedTo, PortNumber, PortName, VLAN, MACVendor, NodeID, FirstSeen " \ "FROM Orion.UDT.AllEndpoints " \ "WHERE ipAddress LIKE '{0}' " \ "OR Hostname LIKE '{0}%' " \ "OR MACAddress LIKE '{0}'".format(query)) print(result) I get…
Looking to see if there is an API or sdk method to update Network Sonar discovery profile IP lists without going at the SQL directly? I've seen sample scripts out here in thwack but seems a bit dated and was wondering if there is now an API and or sdk method to update specific discovery ID PluginConfigurations lists. In my…
How do I change the SQL query to select only certain interfaces?
From SWQL I'm looking for existing/customized poller from local poller library ( Settings / all settings/Manage pollers).
Does versions of Solarwinds Platform , 2023+, can evaluate mathematically (SUM, AVG, ...) numbers coming from custom properties (status field) using strictly SWQL requests ?
It looks like you're new here. Sign in or register to get started.