Comments (5)
Im not sure if SWQL ever supported a wildcard, per the article at https://support.solarwinds.com/SuccessCenter/s/article/Use-SolarWinds-Query-Language-SWQL it states the following.
Based on this information you will need to specify the columns you want to pull explicitly, see the example below.
SELECT NodeID, IPAddress, Caption FROM Orion.Nodes
I have tested both in SWQL studio and in Python3 and that is the case in each instance. I believe (might be incorrect) this is because how the SWQL language was designed and implemented and is expected behavior.
from orionsdk-python.
This is very helpful...thank you. I can now at least look at this documentation to see the available properties for the SWQL. I honestly didn't even know it was called "SWQL" and thought the querying through python was an identical wrapper for regular SQL...maybe I'm remembering wrong and the wildcard '*' didn't used to work in the past.
Anyways, thanks for sharing that link to the SWQL documentation, I never knew it existed.
from orionsdk-python.
Your welcome, another useful tool that I use all the time to help construct different queries and exploring the data and operations available via SWQL is SWQL Studio, you can download it here.
https://github.com/solarwinds/OrionSDK/releases
I highly recommend it as I have found it speeds up the process of developing the correct query your looking for.
from orionsdk-python.
I will try it out, thanks.
from orionsdk-python.
It looks like this question has been addressed, so I'm going to close out the issue.
from orionsdk-python.
Related Issues (20)
- Unable to get resources list of a node HOT 10
- OrionSDK not permanently setting interface status on Node HOT 1
- requests.exceptions.HTTPError: 400 Client Error: Update or insert of view or function 'dbo.NCM_Nodes' failed because it contains a derived or constant field. HOT 1
- SVI showing None for InAveragebps HOT 5
- snmp-testing HOT 5
- SNMPv3 RW Credentials
- Issue with Updating Custom Properties HOT 6
- Unable to find poller_type for creating node HOT 3
- Disabling specific sensors via python HOT 1
- SettingValue(credentialID) is not getting updated HOT 1
- How to test for SNMP credentials using Rest API HOT 2
- Use any port number if specified to initialize client
- HTTP Connection Issue: Authentication Failed
- SwisClient bulkdelete method not in PyPi HOT 1
- SolarWinds Duplicate ICMP Device Listings
- Question on Suppress Alerts
- 403 Client Error: Access to Orion.AlertSuppression.SuppressAlerts verb denied
- pip install orionsdk gets version 0.3 HOT 5
- Connection aborted.', ConnectionResetError(104, 'Connection reset by peer
- Python syntax to override port to use 17774 instead default 17778 to connect to orion ? HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from orionsdk-python.