Hello everyone, I managed to reach a SQL call that helps me a lot, but when using this query the date is coming with a very different time and date, like a week ago. Has anyone had a problem like this using Syslog tables via SWQL? Note: I'm using this in a modern dashboard My query: SELECT TOP 100 DateTime, Level, Message,…
Hello Everyone, I'm making a dashboard about a value that I'm capturing via UnDP, when pulling data from the Orion.NPM.CustomPollerStatus table it returns the status values and name of the VPN in the same table. With SWQL I can take these values and separate them to be able to create a status dashboard for my VPN Example…
I'm running into an issue with getting results back from the NCM component of SolarWinds while using the API. This issue is the same when using the SWQL API or the SWIS API. My workflow is generally to build a query in SWQL Studio and use that query in an API request using the SWQL API. Also, I'll use the SWIS API where it…
Hi The following SQL query retrieve CPU and RAM usage by SAM ComponentID. It shows the last poll result for each component. SELECT DateTime, ComponentID, AvgMemoryUsed, AvgPercentCPU FROM ( SELECT DateTime, ComponentID, AvgMemoryUsed, AvgPercentCPU, ROW_NUMBER() OVER (PARTITION BY ComponentID ORDER BY Datetime DESC) rn…
I need to parse all of the command lines defined in the alerts for action ExecuteExternalProgram against the nodes and applications in our Orion instance so I can move the data we have hard coded into our CMDB (priority/severity, team assignment, etc). I've been searching for days using SWIS and I can't find it. I have…
All, I am looking for some SWQL/SQL code that can pull out the following information from the database. Columns Include: * Device Name * IP Address * Time Down * Time Up * Minutes Node was down
Hi Anyone, Does anyone have any document of API scripting from SolarWinds application to integrate with other 3rd party applications or is anyone aware how achieve this.
Dear Thwack While I run a query mentioned below to fetch Inventory report for nodes, I am facing an error as per below screenshot, please note other queries run successfully. and I have also updated SWQL config file for operation time out to 15 mins. SELECT N.NodeName, N.IP_Address, N.Vendor, n.MachineType,…
Greetings Thwack, I have a collection of scripts that are used for on-boarding new devices into my Orion instance. One of the scripts is responsible for starting an NCM inventory on the new device, and monitoring it until completion before kicking off the next steps in the process. I recently upgraded from 2020.2.6 to…
I am currently working on Solarwinds to Sharepoint integration to update the monthly SLA for different group created in Solarwinds via an API call from share point. Please let me know anybody know API query which can call from Sharepoint, ServerIP:17774/.../Query....... I have created manual report for the group…
It looks like you're new here. Sign in or register to get started.