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



Type: integer. Key. Generated ID

Auto-generated identity number


Type: binary (max 16 bytes). Key

The Action which applies.


Type: integer. Key. Nullable

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


Type: integer. Key. Nullable

Index into the NetworkDevice table for this device.


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

The network hardware address of the device.


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

The DNS name of the device.


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

The IP Address of the device.


Type: integer

One of the action states defined in the ActionState table.


Type: text. Nullable

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


Type: datetime

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