Hi Rene,  Try using this query:  /*List all the virtual desktops with a persistant assignment, and shows the last logon time ordered by user. This can be useful in auditing the usage of virtual desktops by a certain user. */  SELECT [VirtualMachineName]             ,[StaticClientName]             ,[LastTimeLoggedIn] FROM VirtualMachinesRealtime WHERE StaticClientName IS NOT NULL ORDER BY LastTimeLoggedIn  The query is also attached.
Could someone help me with this? We are succesfully running the reporting database with vWorkspace 7.2.  I'm looking for a SQL query that can do the following: List all virtual desktops with their persistant users, and show the last logon or power on time.  This way, I want to report about 'unused' virtual machines that we might clean up. 
Reporting unused VDI machine's