rene11
2 Iron

Reporting unused VDI machine's

Jump to solution

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.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
Highlighted

RE: Reporting unused VDI machine's

Jump to solution

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.

2 Replies
Highlighted

RE: Reporting unused VDI machine's

Jump to solution

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
2 Iron

RE: Reporting unused VDI machine's

Jump to solution

Perfect. Exactly what I was looking for.

Thnx Michel!

0 Kudos