I would like to join the Integration Log records from Service Center with the HTTP Trace that you can see when you click on the 'Detail' of an Integration log record. How can I do this using SQL Sandbox - what tables would I need to join on?
I heard that the tables are normally OSLOG_% but I don't see these? Is it a permissions thing?
Tables are:
- oslog_Integration_1, oslog_Integration_2, oslog_Integration_3 etc
- oslog_General_1, oslog_General_2, oslog_General_3 etc
- oslog_Extension_1, oslog_Extension_2, oslog_Extension_3 etc
It's not accessible from service studio as normal tables, but you can make a query in SQL management, using extension or using the SP from Outsystems.
Thanks Paulo
If you need more details how to make queries let me know!
Thanks Paulo will do.
The SP available to use is: sp_executesql
You should use physical names