Skip to main content

Ticket Counts

How many tickets were opened and resolved over a period, how many are still open, and how long they took to resolve. Use it for a dashboard or a monthly report instead of counting the rows from /v1/tickets.

opened, resolved and cancelled count what happened inside the period: a ticket opened in March and resolved in April counts as opened in March and as resolved in April. open and overdue describe the backlog at the end of the period, or right now while the period is still running.

Ticket counts GET /v1/ticket_counts​

Returns one summary for the period, the same figures broken down by severity, category, source and workspace, and a count for every day.

Query parameters​

  • fromdate

    First day of the period, YYYY-MM-DD in Philippine time. Omit both from and to for the current calendar month.

  • todate

    Last day of the period, inclusive. The range must be 366 days or less.

  • severitystring

    minor, major or critical. Repeat the parameter or pass a comma separated list. Multiple values mean any of them.

  • categorystring

    no_service, topup, suggestion or general. Same list rules as severity.

  • sourcestring

    manual, alert or system. Same list rules as severity.

  • tagstring

    Restrict to tickets that carry any of these tags, e.g. offline. Same list rules as severity.

  • siteCodestring

    Restrict to tickets about devices at one or more sites. Same as on /v1/tickets.

  • gatewayIdstring

    Restrict to tickets about one or more devices. Same as on /v1/tickets.

  • workspaceIdstring

    Scope to a single workspace. Must be one returned by GET /v1/workspaces. An id outside your token's set returns 403.

An unknown severity or category value returns 400 rather than zeros, so a typo can't look like "no tickets".

Response object​

  • fromdate

    First day of the period.

  • todate

    Last day of the period, inclusive.

  • openedinteger

    Tickets created during the period.

  • resolvedinteger

    Tickets resolved during the period, whenever they were opened.

  • cancelledinteger

    Tickets cancelled during the period.

  • openinteger

    Tickets not yet resolved, closed or cancelled at the end of the period, or now while it is still running. Includes tickets opened before the period.

  • overdueinteger

    The open tickets that were past their due time at that moment.

  • medianResolveMinutesnumber

    Median minutes from opening to resolution, over the tickets resolved during the period. null when none were.

  • meanResolveMinutesnumber

    Average minutes from opening to resolution, over the same tickets. null when none were.

  • bySeverityobject[]

    The figures above for each severity: key is minor, major or critical. All three are always listed.

  • byCategoryobject[]

    The same for each category: no_service, topup, suggestion, general, and none for tickets opened without one. All of them are always listed.

  • bySourceobject[]

    The same for manual, alert and system.

  • byWorkspaceobject[]

    The same for each workspace with a ticket in the result: key is its id and name its name.

  • daysobject[]

    One entry per day of the period, oldest first: day (YYYY-MM-DD) and the tickets opened and resolved that day.

GET/v1/ticket_counts
curl "https://polaris.revlv.com/v1/ticket_counts?from=2026-09-01&to=2026-09-30" \
  -H "Authorization: Bearer {token}"
Response
{
  "data": {
    "from": "2026-09-01",
    "to": "2026-09-30",
    "opened": 42,
    "resolved": 38,
    "cancelled": 1,
    "open": 9,
    "overdue": 2,
    "medianResolveMinutes": 312,
    "meanResolveMinutes": 655,
    "bySeverity": [
      { "key": "minor", "opened": 25, "resolved": 24, "cancelled": 1, "open": 3, "overdue": 0, "medianResolveMinutes": 280, "meanResolveMinutes": 410 },
      { "key": "major", "opened": 15, "resolved": 12, "cancelled": 0, "open": 5, "overdue": 2, "medianResolveMinutes": 390, "meanResolveMinutes": 1020 },
      { "key": "critical", "opened": 2, "resolved": 2, "cancelled": 0, "open": 1, "overdue": 0, "medianResolveMinutes": 95, "meanResolveMinutes": 95 }
    ],
    "byCategory": [
      { "key": "no_service", "opened": 31, "resolved": 29, "cancelled": 0, "open": 6, "overdue": 2, "medianResolveMinutes": 330, "meanResolveMinutes": 720 },
      { "key": "topup", "opened": 8, "resolved": 8, "cancelled": 0, "open": 1, "overdue": 0, "medianResolveMinutes": 240, "meanResolveMinutes": 300 },
      { "key": "suggestion", "opened": 1, "resolved": 0, "cancelled": 1, "open": 1, "overdue": 0, "medianResolveMinutes": null, "meanResolveMinutes": null },
      { "key": "general", "opened": 2, "resolved": 1, "cancelled": 0, "open": 1, "overdue": 0, "medianResolveMinutes": 610, "meanResolveMinutes": 610 },
      { "key": "none", "opened": 0, "resolved": 0, "cancelled": 0, "open": 0, "overdue": 0, "medianResolveMinutes": null, "meanResolveMinutes": null }
    ],
    "bySource": [
      { "key": "manual", "opened": 12, "resolved": 10, "cancelled": 1, "open": 3, "overdue": 0, "medianResolveMinutes": 420, "meanResolveMinutes": 600 },
      { "key": "alert", "opened": 30, "resolved": 28, "cancelled": 0, "open": 6, "overdue": 2, "medianResolveMinutes": 300, "meanResolveMinutes": 675 },
      { "key": "system", "opened": 0, "resolved": 0, "cancelled": 0, "open": 0, "overdue": 0, "medianResolveMinutes": null, "meanResolveMinutes": null }
    ],
    "byWorkspace": [
      { "key": "3f6b1c2e-8a4d-4f7a-9c1e-2b5d7e9f0a11", "name": "DICT Region IV-A", "opened": 42, "resolved": 38, "cancelled": 1, "open": 9, "overdue": 2, "medianResolveMinutes": 312, "meanResolveMinutes": 655 }
    ],
    "days": [
      { "day": "2026-09-01", "opened": 2, "resolved": 1 },
      { "day": "2026-09-02", "opened": 0, "resolved": 2 }
    ]
  }
}