web created reports - ability to see SQL

The tables are web bound it seems, but to change your search criteria - this is how I manage it. (essentially I have reports for different area's, and change the Data Source (or filter to nodes for that region).

Manage Reports - Click on your Web Report (or Build new one) - Once you build your tables then you set the data filter, and this is what you see.

Hit the drop down, and change to SQL / SWQL ********

**Note - if you have a query and you change it to SQL, you lose the data (if you save it)... so be sure to HIT CANCEL to not lose your data query.    ** YOU MUST CREATE each NEW SQL QUERY **

           -   I duplicate reports (to keep the table setup) - then EDIT on the Data Filter (or Report Name "FOR" <DROPDOWN>)  -- change the name when you edit so it creates a new set instead of changing the previous set

Hope this helps.

ok, so this is how I'd create a customized report via the web?  report via html?

Thanks for the help!

Report Writer's Reports use SQL. You can view the SQL in Report Writer by opening the Report, then go into Report> Show SQL. a new SQL Tab will display on the Report Tab. This will show the SQL Query used in the Report.

For Web Resources, we do not use SQL, we use our own Query Language called SWQL. You can enable a feature called Hubble to see the loading times of each resource, as well as the SWQL used in the Resources.

To enable Hubble

• go into C:\Program Files (x86)\SolarWinds\Orion\LogAdjuster.exe.
• Change Hubble Active from False to True and select Apply and Close at the Bottom.
• When you refresh the Web Console, the Solarwinds Logo (or Custom Logo) will disappear and be replaced with a Red Bar.
• Clicking on the Red Bar will present you with the Resources that loaded on the Page.
• You will see the the Number of Resources loaded, the length of time it took to load the data, and the SWQL that we use.

If you want to execute SWQL queries from the website interface, than use:

SWISv2: /Orion/Admin/swisv2.aspx - At this page the queries executed from this page are executed against SWISv2

SWISv3: /Orion/Admin/swis.aspx - At this page the queries are executed against SWISv3