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

swql needed for memory usage
Hi - need some swql for memory usage - thanks in advance
SWQL function ARRAYVALUEAT / SPLITSTRINGTOARRAY working in SWQL Studio, but fail in web based reporting
Hello Thwack Team, For the below working query - which works in custom swql dashboard resources and in swql studio, SELECT TOP 1 ARRAYVALUEAT(SPLITSTRINGTOARRAY(Replace('Part1-Part2-Part3-Part4','-','|§|§|')),0) as Field1, ARRAYVALUEAT(SPLITSTRINGTOARRAY(Replace('Part1-Part2-Part3-Part4','-','|§|§|')),1) as Field2, CONCAT(…
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…
Network router - can be controlled by RPC API calls - we have Python script to e.g. reboot the device, or read particular value - how to run such Python script from Solarwinds' GUI/web?
Hi, I'm totally new to Solarwinds NMS. Our company manufactures various routers which can be controlled/managed by API calls (RPC API). This works via HTTPS (login, various calls, logout). I already have multiple Python scripts (or could be other languages, such as Bash, ...) doing the necessary task - e.g. rebooting the…