This document shows examples on how you can query views associated with the log records. Keep in mind that querying views of a live system negatively affects the runtime performance of the environment, because the logging mechanism is optimized for writing. We recommend that you implement your own mechanism for creating copies of the log data, in models designed for the types of searches you need.

select request_key, 'MOBILE REQUEST' log_type, instant,  
'eSpace ID: '||espace_id||'; Screen: '|| screen || '; Endpoint: '||endpoint||'; User ID: '||user_id information, duration  
from oslog_mobile_request  
where request_key = '9c35b89a-2ec3-4716-bb96-4e3ea41b664c'  
union all  
select request_key, 'INTEGRATION', instant,  
'Type: '||type||'; Endpoint: '||endpoint||'; Action: '||action information, duration  
from oslog_integration  
where request_key = '9c35b89a-2ec3-4716-bb96-4e3ea41b664c';

select request_key, 'MOBILE REQUEST' log_type, instant,  
'eSpace ID: '||espace_id||'; Screen: '|| screen || '; Endpoint: '||endpoint||'; User ID: '||user_id information, duration  
from oslog_mobile_request  
where request_key = 'd6aaad9c-1786-4f65-a5c9-b89b84397fd8'  
union all  
select request_key, 'EXTENSION', instant,  
'Extension ID: '||extension_id||'; eSpace ID: '||espace_id||'; Action: '||action_name information, duration  
from oslog_extension  
where request_key = 'd6aaad9c-1786-4f65-a5c9-b89b84397fd8';  

select request_key, 'MOBILE REQUEST' log_type, instant,  
'eSpace ID: '||espace_id||'; Screen: '|| screen || '; Endpoint: '||endpoint||'; User ID: '||user_id information, duration  
from oslog_mobile_request  
where request_key = '18f805aa-7510-4dc1-9f5b-c558647ea3dd'  
union all  
select request_key, 'ERROR', instant,  
'Message: '||message , -1  
from oslog_error  
where request_key = '18f805aa-7510-4dc1-9f5b-c558647ea3dd';