AccessingDeviceSnapshot Table

The AccessingDeviceSnapshot table lists all the snapshotted accessing devices.

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

Database Column



Type: integer. Key

A unique identifier for a AccessingDevice.


Type: integer. Nullable

An identifier for a compliance computer record. Foreign key to the ComplianceComputerSnapshot table.


Type: text (max 256 characters). Nullable

IP address of the of the device.


Type: text (max 256 characters). Nullable

Computer name.


Type: integer. Key

The snapshot ID. Foreign key to the LicenseMeasurement table.