From a previous question, I was able to get the IP address(s) in question however I ran into another issue. The results which should provide an IP address along with an "unknown" IP address based on the two interfaces that I filtered against instead show multiple results for the same two interfaces roughly 39 times. I…
Anyone know what table the interface IP address and Subnet mask is located in? Everything that I am seeing either goes back to outdated information or gives me the node IP address. Any help would be greatly appreciated. I would think it would be under the "Orion.NPM.Interfaces" table but no luck. SELECT…
Hello, after a while I got back to my python code for sending query to orion API. Out of the blue, it stopped working and code returns this error: requests.exceptions.ConnectionError: HTTPSConnectionPool(host='our_server_ip', port=17774): Max retries exceeded with url: /SolarWinds/InformationService/v3/Json/Query (Caused…
When I look at a Node with a critical status in the user interface, the interface says: Active Alerts on This Node (5) ALL UNACKNOWLEDGED ALERTS when I use the API it says the Node doesn't have any Orion.ActiveAlerts: SELECT n.ActiveAlerts.AlertID FROM Orion.Nodes n WHERE n.NodeID = '__NODEID__' returns null. The rest of…
Hello All, I would like some assistance with a powershell script I am writing using swisPowershell to add volume to a node. I have already successfully added a new node, a new interface, custom settings for the node, and also I was able to add virtual memory, physical memory, and a fixed disk drive to the node. Here is my…
Hi Ken, Could you please help in providing the SWQL query for nodes availability for last 7 days for 100% and 0%
I tore the SWQL out of the alert "duplex mismatch", ran it in SWQL studio successfully, but when I try it in report writer it won't even preview the results. Thoughts / comments ? select interfaces.uri, interfaces.displayname from orion.npm.Interfaces LEFT JOIN Orion.TopologyConnections tc ON (tc.SrcNodeID =…
$CorePluginConfigurationContext = ([xml]" $ip $wmiCredentialsId 1 1 1000 ").DocumentElement
Hello Guys, Can anyone help me with NTA reports? Scenario is: There is a request where we need to provide Domain systems Internet usage and Bandwidth used for specific location.
I am trying to add additional information about KBs installed on Servers into our ISM import (all of the nodes, their status, etc). I can see that I get this information from Orion.AssetInventory.OSUpdates However, it lists each KB on a row per nodeid and I want to instead join this query into an existing one to be a…
It looks like you're new here. Sign in or register to get started.