Beacon Table

The Beacon table contains beacon definition.

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 Beacon table

Database Column

Details

BeaconID

Type: integer. Key. Generated ID

Unqiue ID assigned to each beacon.

BeaconUID

Type: unique identifier. Key

Unique string ID of the beacon.

BeaconName

Type: text (max 64 characters)

Name of the beacon.

BeaconDescription

Type: text (max 256 characters). Nullable

Description of the beacon.

BeaconStatus

Type: boolean

Boolean indicating to include or exclude Beacon.

LastKnownActivityTime

Type: datetime. Nullable

Last known time that communication has been received from the beacon.

ActivityStatusID

Type: integer

Last known activity status reported by the beacon.

PolicyDownloadedTime

Type: datetime. Nullable

Policy downloaded time

CurrentPolicyRevisionNo

Type: integer. Nullable

Last downloaded policy revision number

BeaconLocation

Type: text (max 256 characters). Nullable

Location field for Beacon.

PrimaryParentUID

Type: unique identifier. Nullable

The parent of the Beacon. For the core Beacon, the PrimaryParentUID is NULL.

BeaconPassword

Type: text (max 64 characters). Nullable

The password used by the beacon to authenticate with.

HTTPAccessData

Type: text. Nullable

The HTTPEndPointStatus object, used for storing a summary of how to access the sahres on this beacon.

UpgradeModeID

Type: integer

The upgrade mode selected for this beacon.

UpgradeStatusID

Type: integer

The latest information reported by a beacon about any upgrade activity or changes.

LastKnownPolicy

Type: datetime. Nullable

The last known time that the beacon has communicated with the server.

Version

Type: text (max 50 characters). Nullable

Version of installed beacon on the server

WebServerStatusID

Type: integer

The last known time that the beacon has communicated with the server.

UpgradeStatusTime

Type: datetime. Nullable

The time the last upgrade status was reported.

AvailablePackageID

Type: integer. Key. Nullable

If the beacon upgrade mode is set to specific version, then this stored the specific package to upgrade to.

ParentServerURL

Type: text. Nullable

The parent to which this beacon will communicate with.

DownloadURL

Type: text. Nullable

The download URL of the parent.

UploadURL

Type: text. Nullable

The upload URL of the parent.