Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SolarWinds SDK

Recent Discussions

WSQL script for availability
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…
is there any programatic way to add a custom property to interface?
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…
swql needed for memory usage
Hi - need some swql for memory usage - thanks in advance
swql for memory usage -
HI all - have looked around but cant seem to find an swql for memory usage - is there swql available for this
Modern table dashboards
I have been working on a modern dashboard with node details, real time status to be displayed on my noc views. My SWQL query fails, and I am not sure the best way to move forward. Could I get ideas around this?
Is there an SWQL equivalent to MS SQL's String_AGG function?
Is there an SWQL equivalent to MS SQL's String_AGG function? that takes a list of items a combines it into a delimited string. Here is a sample SQL that I would like to do as a single SWQL statement. SELECT top 10 Nodes.Caption, Nodes.NodeID, ( SELECT String_AGG( '['+c.Name+']', ',' ) as GroupList FROM…
How to check if a node has all relevant custom pollers applied to it using SQWL
Hello fellow Community Guru's. I am trying to find a way to report if a node does not have all relevant custom pollers applied. I have tested this code which works. SELECT n.Caption, n.IP_Address, n.Vendor FROM Orion.Nodes n JOIN Orion.Vendors v ON n.Vendor = v.Name WHERE n.NodeID NOT IN (SELECT NodeID FROM…
Alert trigger action message displayed - shorten syslog message with SWQL
Hi all, I have defined an alert to trigger when Cisco interfaces change status to err-disable. The problem is the alert message is quite lengthy: CISCO-SYSLOG-MIB:clogMessageGenerated : sysUpTime = 316 days 16 hours 50 minutes 27.35 seconds, clogHistFacility.31909 = PM, clogHistSeverity.31909 = 5, clogHistMsgName.31909 =…
Solarwinds API
Does SolarWinds have open APIs? If so, how does one obtain the API documentation?
SWQL Historical Node Status Events where a custom property is true
I am trying to build a query and eventually a dashboard for our Remote locations only I cannot seem to get the Node statuses I tried to create an alert to key off of but i do not get the proper node statuses Historical Event Description for the last 30 days Nodes where an Interface has Custom Field: Wan_Interface =True…