sonar-explanation-requests
Enumerate explanation requests in Logpresso Sonar.
sonar-explanation-requests [duration=NUM{mon|w|d|h|m|s}] [from=yyyyMMddHHmmss] [to=yyyyMMddHHmmss] [order=desc|asc] [priority=LOW|MEDIUM|HIGH] [statuses=STATUS,...] [keywords=VALUE] [ticket-guid=UUID] [locale=LOCALE]
- duration=NUM{mon|w|d|h|m|s}
- Optional. Scan only recent data. You should use s(second), m(minute), h(hour), d(day), mon(month) time unit. Either duration or from is required.
- from=yyyyMMddHHmmss
- Optional. Start of search range. yyyyMMddHHmmss format. Either duration or from is required.
- to=yyyyMMddHHmmss
- Optional. End of search range. yyyyMMddHHmmss format.
- order=desc|asc
- Optional. Sort order: desc or asc. Default is desc.
- priority=LOW|MEDIUM|HIGH
- Optional. Filter by priority.
- statuses=STATUS,...
- Optional. Comma-separated status filter. Available values: NEW, SUBMITTED, MANAGER_REJECTED, MANAGER_CLOSED, AUDITOR_SUBMITTED, AUDITOR_REJECTED, AUDITOR_CLOSED
- keywords=VALUE
- Optional. Search keywords
- ticket-guid=UUID
- Optional. Filter by ticket GUID
- locale=LOCALE
- Optional. Locale for category name and status name resolution. If not specified, session locale is used.
Output Fields
| Field | Type | Name | Description |
|---|---|---|---|
| _time | Date | Time | Date and time of creation |
| guid | String | GUID | Explanation request GUID |
| priority | String | Priority | Priority (LOW, MEDIUM, HIGH) |
| category_name | String | Category name | Explanation category name |
| ticket_id | Int | Ticket ID | Related ticket ID |
| ticket_title | String | Ticket title | Related ticket title |
| status_code | String | Status code | Explanation status code |
| status_name | String | Status name | Explanation status display name |
| emp_name | String | Employee name | Employee name |
| manager_name | String | Manager name | Manager name |
| manager_result | String | Manager result | Manager review result (Violation or Normal) |
| auditor_name | String | Auditor name | Auditor name |
| auditor_result | String | Auditor result | Auditor review result (Violation or Normal) |
| owner_name | String | Owner name | Request owner name |
| close_by_manager | Bool | Close by manager | Whether manager can close without auditor |
| user_note | String | User note | Explanation request note |
| log_from | Date | Log from | First log occurrence time |
| log_to | Date | Log to | Last log occurrence time |
| event_from | Date | Event from | Event start time |
| event_to | Date | Event to | Event end time |
| expired | Date | Expired | Submission deadline |
| ticket_guid | String | Ticket GUID | Related ticket GUID |
| category_guid | String | Category GUID | Explanation category GUID |
| emp_guid | String | Employee GUID | Employee GUID |
| auditor_guid | String | Auditor GUID | Auditor GUID |
| owner_guid | String | Owner GUID | Request owner GUID |
| created | Date | Created | Date and time of creation |
| updated | Date | Updated | Date and time of last modification |