This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Get the sql query of web based report.

krishnamishra0786 over 7 years ago

Hi,

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- you log into the Solarwinds Server
- Open Log Adjuster
- At the Top, Change Hubble Active value to "True"
- Click Apply

Now go to the web console and you will see hubble is active on the web interface.

View the report in the same way.
- Click Details in the red menu bar for Hubble
- Scroll 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.

Note - After copy and paste the query, please again change the Value in log adjuster from "true" to "false".

Thanks

Top Replies

bobmarley over 4 years ago +1

Here are some screen shots if it makes it easier to tell what your looking for. 1- you log into the Solarwinds Server - Open Log Adjuster - At the Top, Change Hubble Active value to "True" - Click Apply…

0 mprobus over 7 years ago

Thank you. I had previously looked for ways to get this data and gave up. Started my search again this morning due to some management needs. This saved me a lot of work.
Cancel
Vote Up 0 Vote Down

Cancel
0 krishnamishra0786 over 7 years ago

Hi
It is working but let me know how you find the exact query by given steps
Cancel
Vote Up 0 Vote Down

Cancel
0 mprobus over 7 years ago

I utilized my test server since I am likely the only person using it.
- I exported the report from Prod and Imported to Test
- View the report
- With the results still on the screen, click the details of the Hubble
- Scroll down and the query is near the bottom
- I verified I was getting the correct by looking at the various parameters such as Order by and Group by
Cancel
Vote Up 0 Vote Down

Cancel
0 krishnamishra0786 over 7 years ago

Can u please share the sanpshot
Thanks
Cancel
Vote Up 0 Vote Down

Cancel
0 mprobus over 7 years ago
Cancel
Vote Up 0 Vote Down

Cancel
0 dras2017 over 6 years ago

Hi,
Could I also use this tool to see and copy the code for the SQWL query behind a Orion recourse ?
I have an EOC and want to reproduce recourses with custom SWQL queries.
Do you know if this works ?
Cancel
Vote Up 0 Vote Down

Cancel
0 mohitonline over 5 years ago

Hi
I used the same steps but it did not work for me .
I am using version NPM 12.2.0 can you please check and confirm if Hubble is still working for you.
Cancel
Vote Up 0 Vote Down

Cancel
0 krishnamishra0786 over 5 years ago

Hello,
it is still there, but you need to check the link with main poller with
local host name.
Thanks
On Mon, 13 Aug 2018, 16:44 mohitonline,
Cancel
Vote Up 0 Vote Down

Cancel
0 rebelezna over 5 years ago

So you are saying, if we have a additional webserver, we cant use this function? All IIS is disabled on my main poller.
Cancel
Vote Up 0 Vote Down

Cancel
0 garystorr over 4 years ago

Hi,
I know this is a bit old, but all im getting is the SWQL, not the SQL. Any thoughts at what im doing wrong.
Regards
Cancel
Vote Up 0 Vote Down

Cancel