Hi All, I'm new to SolarWinds and these forums, so if this is in the wrong place, please let me know. I have what should be a simple requirement, however I cannot figure out how to do it or why I can't find any examples online! I am using the SWIS PowerShell modules to install/configure the new 2024.1.0 release (moving…
I am trying to create a SWQL query which shows the Server availability and downtime date, start and end time and error message why it was down. I have created below query to get 30 days but I need downtime date, start time and downtime end time in the report as well. Select N.Caption, N.IP_Address, N.NodeID,…
What I need is to access data from SolarWinds Orion using Ansible, but I only have the web portal user account. I want to know how I can access it, or if it is mandatory for my company to provide me with a user account for this link: "https://{{ orion_host }}:17778/SolarWinds/InformationService/v3/Json/Query" According to…
Hi All, I'm exploring the ability to bulk delete interfaces from a node. I keep getting a 500 error using the following script. Any help or suggestions would be greatly appreciated. I am using the latest version of the SDK (0.4.0) and Orion is 2024.2. import requests from pprint import pprint from orionsdk import…
SELECT E0.Node.Caption , E0.Caption FROM Orion.Volumes AS E0 WHERE E0.Node.Caption = 'Node1' AND E0.Caption = 'VolumeName' AND (E0.VolumeSize < ( SELECT E0.VolumeSize FROM Orion.Volumes as E0 WHERE E0.Node.Caption = 'Node2' AND E0.Caption = 'VolumeName' )) In Orion SWIS Query, this query correctly pulls the node & volume…
Google gives me the way to Clear List of Recent SQL Server Connection From SQL Server Management Studio, as shown within the URL attached below. Clear List of Recent SQL Server Connection From SQL Server Management Studio (scholarhat.com) What is the equivalent procedure for the SWQL Studio App?
Does anybody have an example or link to the SDK that covers the "Orion.APIPoller.ApiPoller.AssignTemplate" Invoke method? "Configuration" & "Parameters" is really what Im looking for. -----update------ I got some help from @klobk What I needed to use is Orion.ApiPoller.ApiPoller CreateApiPollerFromTemplate This basic…
I'm trying to programmatically delete a node from our SolarWinds Orion environment as part of our server decommission process I am automating. I can't seem to find the correct endpoint to target in my POST to the API to do this, and I've searched the scheme documentation for our version (2024.1). I should note I have no…
Hello Team, Getting an error saying SubSequent query not supported. Any help from our team. SELECT c.Name ,StartTime.EventTime AS DownTime ,( SELECT TOP 1 EndTime.EventTime FROM Orion.Events AS Endtime INNER JOIN Orion.Container c ON endtime.NetObjectID = c.ContainerID INNER JOIN Orion.Events AS StartTime ON…
I am trying to covert a date to the datetime format to do some date functions on it and I just cant get it to work. I am trying to get 'Test Schedule' in the datetime format doing the following: SELECT TOP 1 [Nodes].DisplayName , DATETIME((SELECT TOP 1 CurrentValue FROM Orion.NPM.CustomPollerAssignmentOnNode AS cPon WHERE…
It looks like you're new here. Sign in or register to get started.