A virtual desktop template is a method to track software access details in a VDI (Virtual Desktop Infrastructure) environment. It’s a catalog of software applications that specifies which user groups can access the applications. The Virtual Desktop Templates page (Discovery & Inventory > Virtual Desktop Templates) shows the templates used for individual inventory devices that FlexNet Manager Suite has inventory details for.
To see the virtual desktop templates used for multiple machines, use the compliance database table, VDIAccessToComputerMapping. Using the compliance database table will quickly map templates to devices in your FlexNet Manager suite environment.
Below is an example query you can modify to return a list of inventory device names and the template names/types they are mapped to.
USE FNMSCompliance -- Or your Compliance Database equivalent
SELECT device.ComputerName AS 'Inventory device',
template.ComputerName AS 'VDI Name',
AccessMode.ResourceName AS 'Access Mode Name'
FROM VDIAccessToComputerMapping AS map
JOIN ComplianceComputer AS device
ON device.ComplianceComputerID = map.MergingComplianceComputerID
JOIN ComplianceComputer AS template
ON template.ComplianceComputerID = map.TemplateComplianceComputerID
JOIN AccessMode
ON AccessMode.AccessModeID = map.AccessModeID
WHERE device.ComputerName IN ('Machine Name', 'Machine Name', 'Machine Name')
-- Replace 'Machine Name' with the list of Inventory devices that you want to find the mappings for
See the articles below for more information about virtual desktop templates from FlexNet Manager Suite Online Help.
Oct 24, 2022 01:37 PM