session debug

[knowledgeenthus]

HI,

Looking to see how i can enable session debugging in service now, what role is needed to enable session debug

I am looking for SQL Debug and SQL detailed Debug. What role is needed to enable session debug and where do i go to enable it?

[Chuck Tomasi]

Most debugging is under System Diagnostics (with the exception of Security debugging which also appears under System Security.)

Admin role is required for this.

Session debugging is a bit different. It is available to your scoped applications under the application record (System Applications> Applications) from the related link Enable Session Debug.

[knowledgeenthus]

Thanks, I am not seeing system diagnostics, if i dont have the role will i not even see the diagnostics option? do   you happen to have a screenshot of where to enable SQL debugging specifically? If i am doing a asset search will i enable it on that page to see the sql query?

[Chuck Tomasi]

Hi Umair,

Can you provide a bit more detail about what you are doing and why you believe you need SQL debugging? To be honest, it's one of the least frequently debugging options I use because ServiceNow developers don't write SQL queries directly. There may be scripts that use the API to make queries, but it's not SQL, so reading SQL output would require a bit of analysis (which is why I generally don't use it.)

What are you trying to accomplish?

Thanks.

[knowledgeenthus]

Thanks Chuck, The goal is to be able to run sql queries to grab needed data from cmddb as part of automation jobs. From what i have read, we need to use the SQL ODBC driver for this sort of thing by using an odbc account with proper access. The goal is to figure out the queries for the desired data. I read that by using the debug option, i can get that query. Do you have any other suggestions on how to accomplish this?