Beacon Table
The Beacon
table contains beacon definition.
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.
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. |