This post is more than 5 years old
74 Posts
0
10683
Reporting unused VDI machine's
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.
Michel Roth
173 Posts
1
January 26th, 2011 11:00
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.
rene11
74 Posts
0
January 27th, 2011 08:00
Perfect. Exactly what I was looking for.
Thnx Michel!