How can I get the SQL used to generate a report from the web report writer? The old report writer on the server had a way to view the SQL.
Are you asking on how to get the SQL equivalent of a Web base report? or you are asking on how to put an SQL query to generate a report?
The first - old report writer had an option to show the SQL that generated the report. Where is that functionality in the new report writer?
now, there are 2 types of report Origin - Web base and Report Writer (viewed from Orion web console).
To view the SQL content of Report Writer Origin report - you can still view it on Report Writer (RDP Orion Server >> Report Writer >> select the report >> Report (menu bar) >> show SQL).
For Web base report origin - there is no way at the moment to view the SQL content. I suggest you can submit it as a feature request
http://thwack.solarwinds.com/community/feature-request_tht
Really useful option we lost in new web based report.
Created feature request for the same, need votes.
Hi,
You can surely get the SQL query from a web based report by following the below steps.
As normally, we can get the SQL query details of which is made in "report witter", Go to sql tab and get the query details.
But below is the step, it helps we can get the SQL query details which is being used by "Web Based" report.
1) Log on to the Solarwinds Server
Open Log Adjuster by accessing the directory C:\Program Files (x86)\SolarWinds\Orion and search for Log adjusterAt the Top, Change Hubble Active value to "True" Click ApplyNow go to the web console and you will see hubble is active on the web interface. 2)View the report in the same way.
Click Details in the red menu bar for HubbleScroll to the bottom of the Hubble Details page and you will see the SQL Query which we use to pull the report from the Orion Database.
P.S - After copy and paste the query, please again change the Value in log adjuster from "true" to "false".
The best way to get the SQL is to log into the server where the Solarwinds Database is housed. Once logged into the server search All Programs (we are still on Windows Server 2012 R2) so then search for Orion Report Writer or Report Writer and launch it. The console shows you the report and once you click on a report you can get the SQL directly if it has yellow concentric circles near it. Then you click the SQL tab to see the code. It if does not have the yellow concentric circles, then click the report you want to see the code, then chose Report from the menu at the top, one the drop down choose "Show SQL". You can get this code and use it in other applications like Tableau or Power BI and manipulate so that can create more useful dashboards.
I honestly don't know why so many "experts" at Solarwinds or the Thwack board don't know this or have not shared this information. It is very simple. This is he SQL for both web and report-writer reports. If you do not have this feature, I suggest you quickly work with Solarwinds to enable it in your environment.
Cheers!
The question was about the web generated reports. The report writer reports (or legacy reports) can be shown in both the application and web interface, but the web reports are not available in the report writer.
I understood the question fully and the answer I gave gets them to SQL needed to reproduce the reports and use them in say ... Tableau or Power BI. You can get the web generated reports and web reports SQL this way as well.
I don't see the web reports in the filesystem at all, where do you see them?
