NEnetxms
Logs

Get SQL for log query

Changed on

Build and return the SQL statement that POST /v1/logs/{log-name}/query would execute for the same request body, without running it. Intended for troubleshooting and for building reports outside of NetXMS.

The statement reflects the caller's object access constraints and includes the row limit offset + limit, because paging is done by executing the statement as is and then skipping the first offset records.

post/v1/logs/{log-name}/query-sql

Request

  • Base URL
    http://127.0.0.1:8000
  • URL
    http://127.0.0.1:8000/v1/logs/{log-name}/query-sql
  • Auth
    HTTP bearer

Request body

offsetinteger

Number of records to skip

limitinteger

Maximum number of records to return (1 to 10000; offset + limit may not exceed 100000)

Response

SQL statement built successfully

querystring

SQL statement in the syntax of the server's database engine

Changes