nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
- SolarWinds Academy
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
Store

JSON API from SWQL query on a Solarwinds Server

VaishuT

Hi All,

I Need to create JSon API Call for a Solarwinds SWQL Query which on a Solarwinds server in SWQL Studio which can be accessed from a PowerBI Dasboard how can i create it.

Find more posts tagged with

orion swql

swql query

API Call

API

Comments

VaishuT

I have created a PowerShell script that is running and showing the output while running from Solarwinds Server However whenever am trying to access it from the outside of server from client network from where i usually access my SolarWinds but its still showing the error as "hmmm… can't reach the page."

PS Script:

Import-Module SwisPowerShell

$swis = Connect-Swis

Get-SwisData $swis 'SELECT NodeID, Caption FROM Orion.Nodes'

API Token URL : https://xxxxxxxxxxx:17774/SolarWinds/InformationService/v3/Json/Query?query=SELECT%20Caption,%20NodeID%20from%20Orion.Nodes

VaishuT

Not Sure about the mgmt. I'll try for sql DB option

cnorborg

Why don't they want to give them access? Your SQL team could configure a read-only user, and probably even lock down what data / tables they have access to?

VaishuT

@stuartd , My mgmt is not allowing the powerBI team to directly access the Solarwinds DB

hence, they want us to use a API Call insted

stuartd

I'd suggest you could start by reading the answers to your last very similar question.

Over here:

https://thwack.solarwinds.com/discussion/152706/solarwinds-swql-query-connection-with-powerbi-dashboard

Quick Links

Dynamic Interface Dashboard; HTML/JS
I wanted to share a new dashboard a co-worker ( @mblackburn ) came up with to help us better view groups of interfaces and various metrics for each. Using a single HTML widget, we are able to visually compare numerous different interfaces by populating each interface dataset onto its own graph. We are able to view…
PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices