SELECT @@server_uuid as server_uuid, ts, class, event, login_ip,login_user,connection_id,<br>status,connection_type,_client_name,_client_version,<br>command,sql_command,command_status<br>FROM<br>JSON_TABLE<br>(<br>AUDIT_LOG_READ( '{ "start": {\"timestamp\": \"2023-08-16 15:33:37\"}, \"max_array_length\": 500 }' ),<br>'$[*]'<br>COLUMNS<br>(<br>ts TIMESTAMP PATH '$.timestamp',<br>class VARCHAR(20) PATH '$.class',<br>event VARCHAR(80) PATH '$.event',<br>login_ip VARCHAR(200) PATH '$.login.ip',<br>login_user VARCHAR(200) PATH '$.login.user',<br>connection_id VARCHAR(80) PATH '$.connection_id',<br>status INT PATH '$.connection_data.status',<br>connection_type VARCHAR(40) PATH '$.connection_data.connection_type',<br>_client_name VARCHAR(80) PATH '$.connection_data.connection_attributes._client_name',<br>_client_version VARCHAR(80) PATH '$.connection_data.connection_attributes._client_version',<br>command VARCHAR(40) PATH '$.general_data.command',<br>sql_command VARCHAR(40) PATH '$.general_data.sql_command',<br>command_status VARCHAR(40) PATH '$.general_data.status'<br>)) as audit_log;