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

View SQL of Web Reports

I would greatly appreciate the ability to look into the underlying code (SQL and/or SWQL) for web reports as we already can for report writer.

Find more posts tagged with

Status: None

Comments

wluther

you can, by opening the .orionreport file and looking at the sql select section. (sometimes hard to keep track of...)

I have done this numerous times to use as a starting point for some more specific/custom reports.

allanseyberth

Hmm... would you know where it's saving those? I have several reports built in the new web based reports that I can't find where the reportwriter puts 'em (...\SolarWinds\Orion\Reports)

njoylif

really frustrating not being able to see the SQL for these...SW, is there a trick to extrapolating the SQL or swql from the "definition" column?

sean.martinez

Report Writer Reports you are able to view the SQL. In the Report Writer application you will need to open the report that you would like to see, then at the top of the application select Report> Show SQL. A new SQL tab will show up in the Report area and you will be able to view the full SQL Query.

The new Web Reports that we have are stored in the ReportDefinitions Table in the Definition Column. The information is written similar to XML so you will need to find SQL=" within the column and the SQL Query will end at the " TopX=.

njoylif

yea, I need reports from web gui. I'm all over the sql in the win32 app and .orionreport files.

The new stuff...it must only show that if you use SQL or SWQL. the one I'm looking at doesn't have it either of those parameters.

Thx

bardeev

It would be nice

grantallenby

Was this ever implement? or do we still need to use the .orionreport file?

Many Thanks,

saw10

Please provide a way to generate the SQL statement or SWQL for reports created via the Web-Based reporting. There is information that I would like to get to without having a degree in SQL

ekis

One workaround is to access the Orion server that hosts the web console and launch the Log Adjuster tool.

From Log Adjuster, enable all items related to Orion Hubble, click apply.

Then, launch the web report on its own browser tab/page.

You'll notice that there's a section that you can expand to see all the details from Orion Hubble.

From those details, you'll be able to see the SWQL used for generating the web report.

Copy the SWQL query and save it to notepad or somewhere.

Go back to Log Adjuster and disable any Orion Hubble stuff, hit apply.

Hope this workaround options helps.

mkomeara

Or keep using Report Writer. The web reports are too simple and inflexible for many customers.

abdulraheemsidz

SWQL or can we also have native SQL query using these steps ?

richa_arya

Hi,

A very nice workaround to have a background of the web reports.

I have enabled hubble under logadjuster but could not see any Hublle related detail on my web interface.

Can you please let me help me with the screen shot of hubble on web interface ?

Is it present in NPM version 12.0.1?

dc4networks

Thank you for the Reminder Ekis...

Get the sql query of web based report.