VirtualDesktopAccess Table

A VDI device a User has accessed on an end-point.

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

Database Column



Type: integer. Key

The end-point ComputerID. This is a foreign key into the Computer table.


Type: integer. Key

The ID for the user accessing the VDI device. This is a foreign key into the User table.


Type: text (max 64 characters). Key

Computer name of the VDI device.


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

Fully qualified domain of the VDI device.


Type: text (max 256 characters). Key

The template from which the VDI device was cloned.


Type: text (max 64 characters). Key

The type of VDI.


Type: datetime. Key

The time the user logged on to the VDI device.


Type: integer. Key. Generated ID

The ID of the user session to the VDI device.