Hello Community,
I would like to view information about executed SQL queries.
I am using an on-premises OutSystems environment.
I checked the following document, but I could not find the corresponding table mentioned there:
https://success.outsystems.com/documentation/11/monitoring_and_troubleshooting_apps/trace_executed_queries_back_to_your_outsystems_applications/
Is there any way to check this information?
Thank you.
Hello @Yongsu Lee,
If I understood correctly, you mean the actual query executed in SQL Management Studio. You can find it in the “Executed SQL” parameter here, and it works for both on-premises and cloud environments. If you copy the query from this parameter and paste it into SSMS, it will execute successfully.
Hi @Yongsu Lee ,
Greetings,
Can you make sure that the settings has been configured as per the document?
Also make sure a solution publish is done after the settings is applied.
and will be getting a comment link accordingly
Example : /* EmployeeManager.EmployeeFlow.EmployeeList.Preparation.GetEmployees */.
Hope it helps.
Regards,Irfan Ahamed
Hello, @Irfan Ahamed Abdul Shukoor
Thank you very much for your valuable reply.
Just to confirm, are you saying that sys.dm_exec_sql_text or V$SQLTEXT stores both the source information of the query and the executed SQL statement?
It will be pulling you a live query as mentioned in the document, downbelow is the example
/* EmployeeManager.EmployeeFlow.EmployeeList.Preparation.GetEmployees */
SELECT TOP (51) NULL o0, [ENEMPLOYEE].[NAME] o1FROM [OUTSYSTEMS].DBO.[OSUSR_0UL_EMPLOYEE] [ENEMPLOYEE] ORDER BY [ENEMPLOYEE].[NAME] ASC