SwisClient "SELECT *" Issue about orionsdk-python HOT 5 CLOSED

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.