Get Query History
POST {{cb_url}}/livequery/v1/orgs/{{cb_org_key}}/runs/_search
Get all LiveQuery results for a specific organization.
RBAC Permissions Required
Permission (.notation name) | Operation(s) |
---|---|
livequery.manage | READ |
Request Body
{"query"=>"efuykoprimz74d4ys5ugj5unqfphxpuz", "rows"=>"25", "sort"=>[{"field"=>"archive_time", "order"=>"ASC"}], "start"=>"0"}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string |
RESPONSES
status: OK
{"org_key":"ABCD1234","num_found":20820,"results":[{"org_key":"ABCD1234","name":"Check installed browser add-ons on daily basis on Windows endpoints","id":"nbmfpaiiq6gnmsvlnaf6hyyczj1eaejt","sql":"SELECT name, version, path FROM users JOIN firefox_addons USING (uid);","created_by":"MQZ6LW8T6K","destinations":["LQ"],"create_time":"2022-11-28T14:15:00.000Z","status_update_time":"2022-11-28T14:15:00.000Z","timeout_time":"2022-11-28T14:17:00.000Z","cancellation_time":null,"cancelled_by":null,"archive_time":null,"archived_by":null,"notify_on_finish":false,"active_org_devices":29,"status":"ACTIVE","device_filter":{"policy_id":null,"os":["WINDOWS"],"device_id":null,"deployment_type":null,"policy_ids":null,"device_types":["WINDOWS"],"device_ids":null},"recommended_query_id":null,"template_id":"zqbkupel7mzwqehuhlkjnwmcj38ezogj","schedule":{"status":"ACTIVE","recurrence":"MINUTELY","timezone":"America/New_York","rrule":"FREQ=MINUTELY;INTERVAL=15;BYSECOND=0","previous_run_time":"2022-11-28T14:15:00.000Z","next_run_time":"2022-11-28T14:18:00.000Z","cancellation_time":null,"cancelled_by":null},"schema":null,"last_result_time":null,"total_results":0,"not_started_count":27,"match_count":0,"no_match_count":0,"success_count":0,"in_progress_count":2,"error_count":0,"not_supported_count":0,"cancelled_count":0}]}