Reports

SIM list

The SIM list report is a dashboard showing the current state of all SIMs in your account. Use this report to review SIM inventory, check activation and suspension counts, inspect SIM and endpoint details, and export SIM data for inventory management.

This dashboard shows data at the current state for your organization, so there is no date or time filter. The difference between this report and Monthly invoiced SIMs is that a SIM that was active at the beginning of the month and later suspended is reported here as suspended, whereas Monthly invoiced SIMs still includes that SIM for invoicing.

Questions this report answers

  • How many SIMs do I have, and how many are activated or suspended?
  • What is the current status of a specific SIM (for example, activated, suspended, factory test, issued)?
  • Which endpoint is a specific SIM assigned to?
  • What is the ICCID, EID, IMSI, or MSISDN for a specific SIM?
  • How are my SIMs distributed across statuses and form factors?
  • Can I export a full list of my SIMs and their details?
1

Log in to your emnify account.

2

Navigate to Reports.

3

Select SIM list from the report list.

Available data

NameTypeDescription
Total Number Of SIMsTileTotal count of SIMs in your account, regardless of status. A second Total Number Of SIMs (exact value) tile displays the precise count.
SIMs ActivatedTileCount of SIMs with the ACTIVATED status. A second SIMs Activated (exact value) tile displays the precise count.
SIMs SuspendedTileCount of SIMs with the SUSPENDED status. A second SIMs Suspended (exact value) tile displays the precise count.
SIM Repo By StatusPie chartSIM distribution across statuses (for example, ACTIVATED, SUSPENDED, FACTORY TEST, ISSUED).
Form Factor DistributionPie chartSIM distribution across form factors (for example, Triple-Cut 1/2 size Commercial, 1/2/3/4FF (4in1), eSIM).
SIM RepositoryTableEvery SIM in your account with SIM, endpoint, and Workspace details. See SIM repository.

For the pie charts, hover over a segment to see its value and percentage, and use the All and Inv toggles and the arrows below the chart to cycle through categories.

SIM repository

Table listing all SIMs in your account with their details.

ColumnDescription
sim_idUnique SIM identifier
statusCurrent SIM status (for example, ACTIVATED, SUSPENDED, FACTORY TEST, ISSUED)
iccidSIM card identifier (ICCID)
eideUICC identifier for eSIMs (N/A for physical SIMs)
iccid_with_luhnICCID including the Luhn check digit
endpoint_idUnique identifier of the endpoint the SIM is assigned to (N/A if unassigned)
endpoint_nameName of the endpoint the SIM is assigned to (N/A if unassigned)
msisdnPhone number (MSISDN) assigned to the SIM
imsiInternational Mobile Subscriber Identity
Assigned toWhether the SIM is assigned to an endpoint (Yes or No)
WorkspaceWorkspace the SIM belongs to

Each column can be used to sort the table. The table includes a search bar and a dropdown to show 10, 20, 50, 100, or 200 (default) entries.

Filters

FilterRequiredValueDefaultDescription
WorkspaceNoPredefinedNoneSearchable dropdown listing the Workspaces you have access to. Only available with multiple Workspaces.
Tag NameNoPredefinedNoneFilter by SIM or endpoint tag name.
Tag Filter CriteriaYesPredefinedExact Combination
  • Exact Combination: all selected tags must be present per SIM (for example, if you select tag1 and tag2, both must be present along with other possible tags).
  • Partial Combination: at least one selected tag must be present (for example, if you select tag1 and tag2, either or both must be present for each SIM).

Apply filters

1

Click the filter icon at the top of the report to open the Filters panel.

2

Set your desired filters. Use the Workspace and Tag Name dropdowns to select values. If filtering by tags, choose a Tag Filter Criteria to control how tags are matched.

3

Click Apply Filters to update the report.

To reset all filters, click Clear all.

Download report data

To download the full report (up to 500,000 rows), use the SIM Repository table’s download menu and choose Export to .CSV.

Each chart and table in this report includes a menu (vertical dots icon) with download options.

1

Click the vertical dots icon on the chart or table you want to download.

2

Select Download, then choose a format:

  • Export to .CSV — download as a comma-separated values file
  • Export to Excel — download as an Excel spreadsheet
  • Download as image — save a screenshot of the chart or table

The same menu also provides Force refresh to reload the data and Enter fullscreen to expand the chart or table.