is there a way to manage account limitations with a swql query using multiple custom properties?
Does anyone know how to get this interface to show from a SWQL perspective? I Can get any of the subinterfaces to show up but since this interface does not have an associated IP address nothing seems to work. With the code provided I can get the two interfaces I need however if I add the NodeIPAddresses.IPAddress or the…
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
It looks like you're new here. Sign in or register to get started.