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.
I use this "malformed advanced SQL" approach all the time.
I use this "malformed advanced SQL" approach all the time.