---
type: api
title: Create a live query
description: **Spaces method and path for this operation:**
url: https://www.elastic.co/elastic/docs-builder/docs/4493/api/doc/kibana/v8/operation/operation-osquerycreatelivequery
resource: https://www.elastic.co/elastic/docs-builder/docs/4493/api/doc/kibana/v8/operation/operation-osquerycreatelivequery
products:
  - Kibana
---

# Create a live query

- Server: `https://{kibana_url}`

## Paths

- `POST` `/api/osquery/live_queries`
- `POST` `/s/{space_id}/api/osquery/live_queries`

## Description

Refer to [Spaces](https://www.elastic.co/docs/deploy-manage/manage-spaces) for more information.

Create and run a live query.

## Authentication

- Api key: `Authorization: <value>`
  These APIs use key-based authentication. You must create an API key and use the encoded value in the request header. For example: `Authorization: ApiKey base64AccessApiKey`
- Basic: `Authorization: Basic <credentials>`

## Request body

`application/json`

- `agent_all` (boolean) — optional
  When `true`, the query runs on all agents.
- `agent_ids` (string[]) — optional
  A list of agent IDs to run the query on.
- `agent_platforms` (string[]) — optional
  A list of agent platforms to run the query on.
- `agent_policy_ids` (string[]) — optional
  A list of agent policy IDs to run the query on.
- `alert_ids` (string[]) — optional
  A list of alert IDs associated with the live query.
- `case_ids` (string[]) — optional
  A list of case IDs associated with the live query.
- `ecs_mapping` (map string to object) — optional
  Map osquery results columns or static values to Elastic Common Schema (ECS) fields
  Map values (object)
  - `field` (string) — optional
    The ECS field to map to.
  - `value` (union string | string[]) — optional
    The value to map to the ECS field.
- `event_ids` (string[]) — optional
  A list of event IDs associated with the live query.
- `metadata` (object) — optional — nullable
  Custom metadata object associated with the live query.
- `pack_id` (string) — optional
  The ID of the pack you want to run, retrieve, update, or delete.
- `queries` (object[]) — optional
  An array of queries to run.
  - `ecs_mapping` (map string to object) — optional
    Map osquery results columns or static values to Elastic Common Schema (ECS) fields
    Map values (object)
    - `field` (string) — optional
      The ECS field to map to.
    - `value` (union string | string[]) — optional
      The value to map to the ECS field.
  - `id` (string) — optional
    The ID of the query.
  - `platform` (string) — optional
    Restricts the query to a specified platform. The default is all platforms. To specify multiple platforms, use commas. For example, `linux,darwin`.
  - `query` (string) — optional
    The SQL query you want to run.
  - `removed` (boolean) — optional
    Indicates whether the query is removed.
  - `snapshot` (boolean) — optional
    Indicates whether the query is a snapshot.
  - `version` (string) — optional
    Uses the Osquery versions greater than or equal to the specified version string.
- `query` (string) — optional
  The SQL query you want to run.
- `saved_query_id` (string) — optional
  The ID of a saved query.

## Response

OK

`application/json`

Type: `object`

## Code examples

#### Console

```console
POST kbn:/api/osquery/live_queries
{
  "agent_all": true,
  "ecs_mapping": {
    "host.uptime": {
      "field": "total_seconds"
    }
  },
  "query": "select * from uptime;"
}
```

#### curl

```curl
curl -X POST "${KIBANA_URL}/api/osquery/live_queries" \
  -H "Authorization: ApiKey ${API_KEY}" \
  -H "Content-Type: application/json" \
  -d '{
    "agent_all": true,
    "ecs_mapping": {
      "host.uptime": {
        "field": "total_seconds"
      }
    },
    "query": "select * from uptime;"
  }'
```

