SQL Report on Modern Dashboard view

Anyone successfully got a SQL report to show on a Modern Dashboard? It it even possible since Modern Dashboard widgets only appear to use SWQL.

Example of the code:

SELECT TOP 10 RowID, CreateDate, SORTORDER, TYPE, COUNT
FROM XXXXXX.XXXXX.XXXXX <- name of the DB in question on the same DB server

I found this request..

(+) Request the Modern dashboard to be able to support SQL data model - Feature Requests - The Orion Platform - THWACK - SolarWinds Community

Thank you,

Find more posts tagged with

sql

SWQL

modern

sql_report

Dashboards

Accepted answers

All comments

dodo123

Do you have the actual query as your example seems very do-able in swql

sum_giais

Pretty sure modern dashboards are SWQL only.

I upvoted the feature request for SQL data models in modern dashboards. If its not within the Orion database or more specifically the SWQL data structure you won't be able to get at the data within SWQL or modern dashboards.

Think of this scenario - you have supplemental node, user, or configuration data within a separate database, a.k.a. auxiliary database (hosted on the same SQL server) and the user Solarwinds uses to acces its database has access to this also. With a SQL query this could be accessed and leveraged in numerous different ways that could benefit the business or your custom environment.

There's a number of use cases and even examples of why you may want to be able to access and reference a separate (auxiliary if you will) database within the SolarWinds Orion environment.

Anyways just trying to add some clarity from what I believe to be @smalleggo's goal here perhaps. Do correct if I've mistaken that!

smalleggo

You would be correct. It's a DB that is not associated with SW so SWQL would not work in this case. The attempt is to provide data from an application but I believe I'll need to go another way about it. Everything I've read/seen shows that SWQL is the only option.

I can create a report using SQL and display the report on a normal view but unfortunately (2+ years) SolarWinds has taken a backseat when it comes to the Modern Dashboard.

Thank you for responding and validating my understanding. I appreciate it.

dodo123

Ok so if its data not being monitored by SolarWinds can it be added then you will be able to use the data in the modern dashboard or any other feature using swql. The data needs to be in the Solarwinds database for it to be used in Orion console. SAM would be where I would start