Hi - need some swql for memory usage - thanks in advance
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(…
HI all - have looked around but cant seem to find an swql for memory usage - is there swql available for this
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? 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…
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 =…
Does SolarWinds have open APIs? If so, how does one obtain the API documentation?
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…
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…
Hi All, Hi everyone, I hope you all are doing well. Currently I'm trying to have a Dashboard in my enviroment to display the number of Active alerts between Critical Alerts and Warning Alert, but for some reason that I cannot see in my code it is not bringing the correct numbers of active alerts for each of them. Would…
It looks like you're new here. Sign in or register to get started.