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

Details

AccessingDeviceID

Type: integer. Key

A unique identifier for a AccessingDevice.

ComplianceComputerID

Type: integer. Nullable

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

IPAddress

Type: text (max 256 characters). Nullable

IP address of the of the device.

ComputerName

Type: text (max 256 characters). Nullable

Computer name.

LicenseMeasurementID

Type: integer. Key

The snapshot ID. Foreign key to the LicenseMeasurement table.