Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

swis query not returning results

I am setting up a SAM monitor using python and testing the swql query i want to run does not return any results even though when i run the query in swql studio it does.

I also tested another query and it does return result

Anybody able to assist ?

thanks

Query that works:

def EngineIDquery():

results = swis.query("SELECT EngineID FROM Orion.Engines WHERE ServerName=@Sysname", Sysname=system)
print(results)
engineid=(results['results'][0]['EngineID'])
print(engineid)

and this is the print output

{'results': [{'EngineID': 10}]}
10

Output from swql studio

Query that returns blank

def cfgchange():
change = """SELECT Nodes.Displayname FROM Orion.Nodes as Nodes
JOIN NCM.Nodes as n on Nodes.NodeID = n.CoreNodeID
JOIN NCM.ConfigArchive as c on n.NodeID = c.NodeID
WHERE Nodes.Vendor LIKE '%uroam%'
AND c.ConfigType = 'Running'
AND ModifiedTime >=DATETRUNC('HOUR',ADDHOUR(-72,GETUTCDATE()))
"""
result = swis.query(change)
print(result)
table = (result['results'])
print(table)

print outputs are

{'results': []}

[]

Output from swql studio ( i subsituted sensitive data for modified time column)

Find more posts tagged with

Accepted answers

All comments

monitoringlife

Not familiar with "DATETRUNC" in SWIS. I personally use ADDDATE without issue.

ex: ADDDATE('Minute', -30, GETUTCDATE())

fraser-sky

Thanks for the reply

But even using that format

AND ModifiedTime >=ADDDATE('HOUR',-72,GETUTCDATE())

I get the same outcome, the query returns results when running it in swql studio but when running from python script results are blank

KMSigma.SWI

# 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  = 'orion.demo.lab' # Put your server ip/hostname here

    change = '''
    SELECT Nodes.Displayname FROM Orion.Nodes as Nodes
    JOIN NCM.Nodes as n on Nodes.NodeID = n.CoreNodeID
    JOIN NCM.ConfigArchive as c on n.NodeID = c.NodeID
    -- I don't have any matching elements here, so I elected to just remove the filter
    --WHERE Nodes.Vendor LIKE '%uroam%'
    AND c.ConfigType = 'Running'
    AND ModifiedTime >= DATETRUNC('HOUR',ADDHOUR(-72,GETUTCDATE()))
    '''

    # 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(change)

    # there are multiple responses, so we'll need to go through each entry
    print("DisplayName")
    for result in response['results']:
        # output the caption and uri
        print(result['Displayname'])

requests.packages.urllib3.disable_warnings()

if __name__ == '__main__':
    main()

The above is returning the following for my environment (SolarWinds Platform 2023.1)

Enter the username and password for 'orion.demo.lab'
Username: admin
Password: 
DisplayName
AP6-2nd
AP6-Ground
AP6-3rd
AP6-1st

Are you sure you are extracting the contents from the returned results properly?

fraser-sky

Thanks for your input

I used your format and i get the same result

======= RESTART: C:/Users/xxxx/Desktop/Python tests/Test-main-query.py ======
DisplayName
>>>

original python script

##omitted connection to server##

So both queries run but i only see results from engineid, i dont see any results to extract from cfgchange

========= RESTART: C:\Users\xxxx\Desktop\Python tests\Test-query.py =========
{'results': [{'EngineID': 10}]}
10
{'results': []}
[]
>>>

If i hash out engineid() so only cfgchange runs its the same thing no results, yet running that exact query in swql studio returns the results i am after

fraser-sky

I worked around this issue and go direct to the device to check the last commit date