Skip to content

Logs

Browse logs

HTTP
1
2
{{host}}/api/core/logs/browse
Authorization: Basic api:{{token}}

Log properties

  • EventId
    • 0-599 HTTP status codes.
    • 600-9000 custom jetQuery codes
  • pid - SRSID
  • username - user
  • requestpath - URL e.g. {{host}}/api/srs/100-dashboard/api.ocase.json
  • ms - time in ms
  • msg - optional url
  • ip - IP
  • TimeStamp - UTC time
  • Host - URL
  • properties
    • User-Agent - browser
    • Client - ui version
    • query - query string e.g. ?pscope=activeUsers,monthSummary,warehouseDateStock&date=2023-05-31&app_name=erp
    • Method - GET/POST
    • debug - additional txt details about request

EventId codes

# Description
HTTP 1xx: Informational — The request has been received and the process is continuing.
HTTP 2xx: Success — The action was successfully received, understood, and accepted.
HTTP 3xx: Redirection — Further action must be taken in order to complete the request.
HTTP 4xx: Client Error — The request contains incorrect syntax or cannot be fulfilled.
HTTP 5xx: Server Error — The server failed to fulfill an apparently valid request.
jetQuery 6xx: Informational — Action was started
jetQuery 7xx: Success — Action was completed successfully.
jetQuery 8xx: Handled Error — Action failed, canceled or crashed

jetQuery - EventId codes

all custom EventId > 600 are also written in app.log db object

  • 6xx
    • 601 Automation started --info
    • 602 Mail pull started
  • 7xx
    • 701 Automation Succeeded
    • 702 Mail pull Succeeded
    • 703 Mail send Succeeded
  • 8xx
    • 801 Automation Failed (handled error, stderr present)
    • 802 Automation Canceled
    • 803 Automation Crashed (unhandled exception)
    • 804 Mail pull Failed (handled error, stderr present)
    • 805 Mail pull Canceled
    • 806 Mail pull Crashed (unhandled exception)
    • 807 Mail sent failed

Example: Get all logs for automation A002-tools-minimal:

SQL
1
select * from log where eventid = 701 and requestpath ='A002-tools-minimal'

Example: Get all mail accounts succesfully get

SQL
1
select * from log where eventid = 702 and requestpath ='mailaccount name'

Historia dla uzytkownika:

SQL
1
2
3
4
5
6
7
8
select * from log where username = @username  --wszystkie operacje
select * from log where requestpath = '/api/core/account/login' and username = @username and message not like '%TOKEN%' --za wyajtkiem tokenow serwisowych
select * from log where requestpath = '/api/core/account/logout' and username = @username
select * from log where requestpath = '/api/core/account/change-password'  and username = @username
select * from log where requestpath = '/api/core/account/recover-password/@username' 
select * from log where requestpath = '/api/core/account/lock/@username'  --administracyjne
select * from log where requestpath = '/api/core/account/unlock/@username' --administracyjne
select * from log where requestpath = '/api/core/token/create/support/@username' --administracyjne