I need to troubleshoot an integration API that runs at a very high frequency.
One element written in the audit event logs appears as a string in the in the Associated Logs for the Audit Event entries.
How can I run a SQL query searching for that string?
1) In which SQL table is that data stored ? In which SQL column?
2) Can that column be queried with a LIKE 'value%' statement?
Thank you for your response.
this is the sql script for a service's last 1 hour audit logs(with associated logs) which we use may help,
we will be pleased for performance tips :)
SELECT ssg.goidToString(m.goid) goid_str, m.time, DATE_FORMAT(FROM_UNIXTIME(m.time / 1000), '%d.%m.%Y %H:%i:%s') AS 'time_formatted', service.routing_uri, msg.operation_name, m.name as full_service_name, service.name service_name, uncompress(msg.request_zipxml) as request_xml, uncompress(msg.response_zipxml) as response_xml, msg.status, msg.response_status , (select json_arrayagg(json_object ("pos", adp.position,"val",adp.value)) from audit_detail_params adp ,audit_detail ad where ad.audit_goid=m.goid and adp.audit_detail_goid=ad.goid and adp.value is not null group by ad.audit_goid) FROM audit_main m LEFT JOIN audit_message msg ON m.goid = msg.goid LEFT JOIN published_service service ON service.goid = msg.service_goid WHERE m.time > unix_timestamp(now() -Interval 1 Hour)*1000 and service.routing_uri='/routing_uri_of_service' ORDER BY m.time DESC limit 100
Thanks - I will give that a go, and provide some feedback.