ActionApplies Table

An action applies/applied to this computer, which can be identified by its computer id, device id, DNS, IP or MAC address. One of the five related cross-references must be non-null. If more than one is non-null, precedence is applied top to bottom in the order documented below.

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

Database Column

Details

ActionAppliesID

Type: integer. Key. Generated ID

Auto-generated identity number

ActionUID

Type: binary (max 16 bytes). Key

The Action which applies.

ComputerID

Type: integer. Key. Nullable

The computer id of the device to which the Action applies. Index into the Computer table.

DeviceID

Type: integer. Key. Nullable

Index into the NetworkDevice table for this device.

MACAddress

Type: text (max 18 characters). Key. Nullable

The network hardware address of the device.

DNSName

Type: text (max 128 characters). Key. Nullable

The DNS name of the device.

IPAddress

Type: text (max 64 characters). Key. Nullable

The IP Address of the device.

ActionStateID

Type: integer

One of the action states defined in the ActionState table.

FailureReason

Type: text. Nullable

If not empty, text describing the reason the action failed.

LastUpdate

Type: datetime

The last time that the state of this action was updated. This value is the UTC date-time of the event.