This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Using SWQL in External Application (Python or Powershell)

map3696 over 7 years ago

Hi All,

I am trying to access my Orion Database to create an external application that displays the percent utilization of the WAN on my network. I have the SWQL Statement and have played around with connecting through Python and through Powershell with no success. Does anyone have any ideas on the direction I need to go to? I tried downloading the SDK from GitHub but i'm not really sure how to use it / get it to work. I'm new to a lot of this and any guidance is super appreciated!

When trying to access the Server through Python I am getting this error:

When trying to access the server through PowerShell I am getting this error:

I try to log in here :

and then get this error:

To create this login window I followed a video that I Watched on YouTube from the SolarWinds Lab.

I am able to connect through the SWQL Studio but when trying to connect through Python or Powershell I am extremely unsuccessful.

I'm not sure if I'm just totally off with my methodology or what's going on. Again any advice is really helpful and appreciated I'm open to any platform, I'm trying to find the easiest and most efficient way to eventually create an external application that can query the server to display information on our sharepoint site.

0 chad.every over 7 years ago

I haven't tried doing exactly what you're doing but I created a script that can modify a custom property. You can check out how i authenticated to the API. I'm just using the rest API, not the powershell snap-ins. So you can use it in posh or port it over to python.
PowerShell script to modify a NODE Custom Property via Rest API/JSON
Cancel
Vote Up 0 Vote Down

Cancel
0 map3696 over 7 years ago in reply to chad.every

My problem is that when supplying my credentials it's not allowing me to log in . I'm going to take a look at your file though! Thanks!
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 7 years ago

I can't see enough of your code in PowerShell or Python to say what's going on. Could you copy and paste it into a message in this thread? (You can xxxx out passwords, of course.) Also include the full text of any errors you get.
Cancel
Vote Up 0 Vote Down

Cancel
0 map3696 over 7 years ago in reply to tdanner

I was actually able to get connected via Powershell. I re-started and must have originally set something up the wrong way. Now i'm struggling to figure out how to integrate this information into an external application. I appreciate your help though
Cancel
Vote Up 0 Vote Down

Cancel