ImportedRemoteUserSIDToApplicationAccess Table

The ImportedRemoteUserSIDToApplicationAccess table stores the applications that Citrix remote users have access to

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 `ImportedRemoteUserSIDToApplicationAccess` table
Database Column	Details
`ComplianceConnectionID`	Type: integer. Key. Nullable The identifier for a data source connection in the `ComplianceConnection` table.
`VDIGroupUUID`	Type: unique identifier. Key. Nullable The desktop group UUID from which the application is published
`ExternalFileID`	Type: big integer. Key. Nullable The identifier used in the source connection for the file evidence.
`ExternalInstaller EvidenceID`	Type: big integer. Key. Nullable The identifier used in the source connection for the installer evidence.
`SID`	Type: text (max 512 characters). Key. Nullable The security identifier for user having access to application.
`AccessModeID`	Type: integer. Nullable The access mode ID for the remote application access.
`InventoryDate`	Type: datetime. Key. Nullable The time when inventory was collected for the application.
`SiteName`	Type: text (max 512 characters). Nullable The Citrix Virtual App site where the evidence was found.