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

Details

ComputerID

Type: integer. Key

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

UserID

Type: integer. Key

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

MachineName

Type: text (max 64 characters). Key

Computer name of the VDI device.

MachineDomain

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

Fully qualified domain of the VDI device.

VDITemplateName

Type: text (max 256 characters). Key

The template from which the VDI device was cloned.

Type

Type: text (max 64 characters). Key

The type of VDI.

LogonTime

Type: datetime. Key

The time the user logged on to the VDI device.

VirtualDesktopAccessID

Type: integer. Key. Generated ID

The ID of the user session to the VDI device.