Is it possible to get the actual SQL Query generated by SBM to display a specific report created using the SBM UI?
I tried the SQL Profiler, but I am wondering if I could use something else!
Thanks!
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
Is it possible to get the actual SQL Query generated by SBM to display a specific report created using the SBM UI?
I tried the SQL Profiler, but I am wondering if I could use something else!
Thanks!
A hack way to do it is add an Advanced SQL condition to the report that is malformed. The entire SQL will be logged to the server's application event log and then you can just ignore the bit that you added.
if I add ( where 1=1) in the advanced SQL condition, will that log the full query to the application event viewer?
That looks close to being syntactically correct. Just put "bad" or something otherwise very non-sql :)
That looks close to being syntactically correct. Just put "bad" or something otherwise very non-sql :)
I just noticed that we can't use 'Use Basic Conditions' with 'Use Advanced SQL Conditions' in the search filter section of the report, if the report has already some defined conditions using the' Basic Conditions' option then how can we handle that, please?