SELECT N.Caption AS Node, N.IPAddress AS Node_IP, I.Name AS Node_Int, NCE.DeviceId AS AP_Name, NCE.IpAddress AS AP_IP, NCE.DevicePort AS AP_Int FROM Orion.NodeCdpEntry NCE INNER JOIN Orion.Nodes N ON N.NodeID = NCE.NodeID INNER JOIN Orion.NPM.Interfaces I ON I.NodeID = NCE.NodeID AND I.Index = NCE.IfIndex WHERE AP_Name…
Hi, I'm using the 'DiscoverAndAddInterfacesOnNode' script from Github. # The node ID to discovery interfaces on $nodeId = 99 # Discover interfaces on the node $discovered = Invoke-SwisVerb $swis Orion.NPM.Interfaces DiscoverInterfacesOnNode $nodeId if ($discovered.Result -ne "Succeed") { Write-Host "Interface discovery…
Hi all, I've created a script that assigns pollers to certain interfaces over network devices like a switch, etc. This script was written in Python and tested successfully, as a premise it receives the node name (caption) and SwisClient connection. It uses the AddInterfacesOnNode Verb to assign the Pollers and…
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.
It looks like you're new here. Sign in or register to get started.