The most recent content from our members.
I am tiring to search for the RawStatus of a Node based on Datetime. This is what I have so far but I cannot figure out how to modify this to search for the date and time. SELECT [Node].NodeID , [Node].CustomPollerStatistics.DateTime , [Node].CustomPollerStatistics.RawStatus FROM Orion.NPM.CustomPollerAssignment AS [Node]…
I am interested in leveraging SWQL and SDK but my knowledge is lacking in these two areas. Any advise about training resources for theses both would be greatly appreciated.
This is an overly simplified guide for "Keep the lights on" SQL to "Expert" SQL users wanting to jump into SolarWinds Query Language (aka Orion API) as fast as possible. Who can use SWQL? * Any user that has web credentials to the web console can use those credentials to run scripts. What is SWQL? * Orion SWQL or…
Hello, I am attempting to run a node availability query via the SolarWinds API but for some reason I am getting different results than when I run the availability report via the web-report or report-writer (which both get the same result). In the web-report I can specify the previous month and in the report-writer it uses…
Is there a way to add a credential via the SWQL API? If now, how can I do this via the SQL and what is the encryption I need to use to put the password in? I would like to bulk add credentials for several nodes. Each node has it's own credential information. I am currently using the REST calls with Invoke / Create, so I…
Using Powershell and the SDK, this script will allow you to change the management state of nodes, interfaces, or applications, and updates a custom property [Unmanaged_Reason] for each element. Create the Unmanaged_Reason property on each element Update the file page [$importfile] to point to your CSV file, or update the…
Hi, I wanted to create a Java Program which could run Queries and give me an output for the Queries. I already have it in Python but specifically wanted it for Java. Can anybody help me with Java program. import requests import json from getpass import getpass """ Make sure to set a valid nodeID in line 50 before using!…
Hi, I wanted to create a Java Program which could run Queries and give me an output for the Queries. I already have it in Python but specifically wanted it for Java. import requests import json from getpass import getpass """ Make sure to set a valid nodeID in line 50 before using! """ class SwisClient: def __init__(self,…
I am trying to query for the hostname of an IP Address? I have tried querying everything under IPAM.IPNode and cannot seem to find where the hostname is hiding????
It looks like you're new here. Sign in or register to get started.