OrionSDK Query Function Python

cedgecombe

Having issues with the query function within the OrionSDK not building the API request correctly. Instead of building the URL "">MYSOLARWINDSINSTANCE.com:17774/.../Query I am getting "MYSOLARWINDSINSTANCE.com:17774/.../Query" causing [Errno 11001] getaddrinfo failed. 

The first URL listed can be accessed and returns successfully when I specify the URL in a GET request. Ex: requests.get("">MYSOLARWINDSINSTANCE.com:17774/.../Query) just not when using the query function. 

Accessing SolarWinds version 2023.1.0 using version 0.4.0 of the OrionSDK for Python.

Code:

import requests

from orionsdk import SwisClient

from orionsdk import solarwinds

def main():

server = "MYSOLARWINDSINSTANCE"

Username = "username"

password = "password"

response = requests.get(server, auth=(username, password), verify=False)

swis = SwisClient(server, username, password)

results = swis.query("SELECT NodeID from Orion.Nodes")

print(results)

main()

KMSigma.SWI

How about this?  This is some sample code I use.

# requests is needed for the underlying web calls
import requests
# getpass is required for password input without displays
import getpass
# orion sdk is required for the client connectivity
from orionsdk import SwisClient

# main() is our main function to do the thing
def main():
    # these are the variables where we store your connection information
    hostName  = 'kmshcoppe01av.kmsigma.local' # Put your server ip/hostname here

    # This is the query we are using
    swqlQuery = """
    SELECT [Nodes].Caption
         , [Nodes].IPAddress
         , [Nodes].Uri
    FROM Orion.Nodes AS [Nodes]
    """

    # Build a connection to the server
    print("Enter the username and password for '" + hostName + "'")
    username = input("Username: ")
    password = getpass.getpass(prompt='Password: ')
    swis = SwisClient(hostName, username, password)

    # let's run the query and store the results in a variable
    response = swis.query(swqlQuery)

    # there are multiple responses, so we'll need to go through each entry
    print("Caption @ IP [URI]")
    for result in response['results']:
        # output the caption and uri
        print("{Caption} @ {IPAddress} [{Uri}]".format(**result))

requests.packages.urllib3.disable_warnings()

if __name__ == '__main__':
    main()