Retrieve query generated for database view in servicenow

[rajranbhare]

Hello,

I want to know what sql query is being generated for a database view in servicenow. How can I do that?

Thanks,

Rajnandini

[sergiu_panaite · Accepted solution]

Enable debug mode "Debug Detailed SQL", go to Database Views, enter the your database view record, and click Try It. At the bottom of the page there you will find the SQL. Disable the debug mode after the test.

[ChaitanyaKanuri]

how to enable Debug Detailed SQL??

[Alikutty A]

Hi Raj,

Why do you require the SQL query? This is internal and Service Now will handle the SQL at database level.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[rajranbhare]

Hello Alikutty,

I want to check whether query is being generated in right or wrong.

thanks,

Raj