Get unified query history
Spaces method and path for this operation:
<div><span class="operation-verb get">get</span> <span class="operation-path">/s/{space_id}/api/osquery/history</span></div>Refer to Spaces for more information.
Get a unified, time-sorted history of live, rule-triggered, and scheduled osquery executions. The response uses cursor-based pagination.
Query parameters
The number of results to return per page.
The number of results to return per page.
A base64-encoded cursor for pagination. Use the value from the previous response to fetch the next page.
A base64-encoded cursor for pagination. Use the value from the previous response to fetch the next page.
A search string to filter history entries by pack name, query text, or query ID.
A search string to filter history entries by pack name, query text, or query ID.
Comma-separated list of user IDs to filter live query history.
Comma-separated list of user IDs to filter live query history.
Comma-separated list of source types to include. Valid values are live, rule, and scheduled.
Comma-separated list of source types to include. Valid values are live, rule, and scheduled.
The start of the time range filter (ISO 8601).
The start of the time range filter (ISO 8601).
The end of the time range filter (ISO 8601).
The end of the time range filter (ISO 8601).
Response
Indicates a successful call.
Example response
{
"data": [
{
"actionId": "609c4c66-ba3d-43fa-afdd-53e244577aa0",
"agentCount": 5,
"errorCount": 0,
"id": "3c42c847-eb30-4452-80e0-728584042334",
"queryName": "uptime_query",
"queryText": "select * from uptime;",
"source": "Live",
"sourceType": "live",
"successCount": 5,
"timestamp": "2024-07-26T09:59:32.220Z",
"totalRows": 42,
"userId": "elastic"
},
{
"agentCount": 10,
"errorCount": 1,
"executionCount": 3,
"id": "pack_my_pack_uptime_3",
"packId": "42ba9c50-0cc5-11ed-aa1d-2b27890bc90d",
"packName": "My Pack",
"plannedTime": "2024-07-26T09:00:00.000Z",
"queryName": "uptime",
"queryText": "select * from uptime;",
"scheduleId": "pack_my_pack_uptime",
"source": "Scheduled",
"sourceType": "scheduled",
"successCount": 9,
"timestamp": "2024-07-26T09:00:00.000Z",
"totalRows": 100
}
],
"hasMore": true,
"nextPage": "eyJhY3Rpb25TZWFyY2hBZnRlciI6WzE3..."
}