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

Engine ID from python swql query

I am trying to get the engine id from a swql query using python but my output is blank.

Running query in swql direct and i get the required result

My code is:

session = requests.Session()
session.timeout = 30
swis = orionsdk.SwisClient(npm_server, username, password, session = session)

results = swis.query("SELECT EngineID FROM Orion.Nodes WHERE NodeName = 'xxxxxxxxx'")

for row in results['results']:
print("{EngineID}".format)

I have tried different print statements but either give me error or is blank.

#print(results["{EngineID}"].format)
#print("{NodeID} [{NodeName}] : {InterfaceID} [{InterfaceName}]".format(**row))
#engineID = results['results']
#print("{EngineID}".format)

Could someone where i am going wrong or if i am missing something.

Thanks

Find more posts tagged with

Accepted answers

mrxinu

print(results['results'][0]['EngineID']) maybe?

All comments

mrxinu

Hey there,

You're assigning the current row to 'row' and then you're not using it in your variable. Change EngineID in the curly braces to row.EngineID.

fraser-sky

Thanks for the reply I have found my mistake, I was connecting to the wrong swql server in my pythn script so my result was right as there was no entry ( insert face palm emoji)

I do have another question though , the result will only ever produce a single line, how would i get it to print only the Engine ID nad not the format

print(results)

Output = {'results': [{'EngineID': 1}]}

mrxinu

print(results[0]['EngineID'])

fraser-sky

Gave that a try and now get error:

print(results[0]['EngineID'])
KeyError: 0

I get the right output when using :

for row in results['results']:
print("{EngineID}".format(**row)

But just want the single output as I want to use it as a variable in the script.

swql query code =

results = swis.query("SELECT EngineID FROM Orion.Nodes WHERE SysName=@Sysname", Sysname=system)

print(results)