We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Generate SQL Query From Report

SumitBanerjee92
Tera Contributor

Hi All,

 

I have a requirement to generate the SQL Query of a report , the query should contain everything starting from filter conditions , the results and all available fields. I tried checking the SQL Debug functionality , but I am not understanding which SQL query is the exact for that report as a lot of queries are getting generated. Any assistance on this is highly appreciated.

 

Thanks

Sumit

1 REPLY 1

Maik Skoddow
Tera Patron

Sorry, never heard such a strange question before. You already figured out there are many SQL queries in the background und therefore you will not get everything in one. Please explain what you would like to do with such a query as we don't have access to the database.