Activity Table

The Activity table stores errors and events processed by the beacon, devices, rules etc.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for Activity table

Database Column



Type: integer. Key. Generated ID

Synthetic key for this table.


Type: integer

The source type ID such as Beacon, External and so on


Type: text (max 256 characters)

The source type name such as Beacon, External and so on


Type: integer. Key

Foreign key to the ActivityType table.


Type: unique identifier. Key

UID to uniquely identify the activity.


Type: datetime

Time that the activity is created in the database.