SIM_STATUS_COUNTS

Daily SIM counts grouped by lifecycle status.

SIM_STATUS_COUNTS contains daily SIM inventory counts by lifecycle status. Use it for status distribution dashboards and inventory trend reports.

Public Contract

• Rows are limited to the current SORACOM Query request context.

Data Freshness

Updated daily.

Columns

Column	Type	Description
SNAPSHOT_DATE	DATE	Date the SIM counts were captured.
OPERATOR_ID	TEXT	Operator identifier associated with the row.
STATUS	TEXT	SIM lifecycle status for the aggregated rows.
SIM_COUNT	NUMBER	Number of SIMs for the status.

Common Queries

Latest SIM counts by status:

SELECT
  STATUS,
  SUM(SIM_COUNT) AS sim_count
FROM SIM_STATUS_COUNTS
WHERE SNAPSHOT_DATE = (
  SELECT MAX(SNAPSHOT_DATE) FROM SIM_STATUS_COUNTS
)
GROUP BY STATUS
ORDER BY sim_count DESC;

Status count trend:

SELECT
  SNAPSHOT_DATE,
  STATUS,
  SUM(SIM_COUNT) AS sim_count
FROM SIM_STATUS_COUNTS
GROUP BY SNAPSHOT_DATE, STATUS
ORDER BY SNAPSHOT_DATE, STATUS;