VMware Horizon Community
jason2727
Contributor
Contributor
‎03-04-2015 07:17 AM

SQL Query - "Last Log on in" VMWare View Virtual Desktop

Hi All -

We are running out of room on our datastores to spin up additional VMWare View virtual desktops for our end users.  We know there are VMs out there that are just sitting idle and have not been used in a while.  We'd like to clean this up.

I've been searching for a "last log in time" or something that would indicate whether the VM has been used within the last 180days so that we can delete them.  I'm not finding anything out there that would help me with this goal.

Is there a SQL table with this information or something similar?

Please let me know.

Reply
0 Kudos
4 Replies
mittim12
Immortal
Immortal
‎03-04-2015 07:23 AM

Are these dedicated pools or floating pools?   On our dedicated pools we use the events data to determine if a user has logged in over the course of 90 days. 

Reply
0 Kudos
jason2727
Contributor
Contributor
‎03-04-2015 07:25 AM

All virtual desktops are assigned to individual users.

Does that help?

How are you querying the events data? 

Reply
0 Kudos
mittim12
Immortal
Immortal
‎03-04-2015 10:18 AM

The events data is kept in a SQL backend.   We just have a SQL query that allows us to specify a user and the amount of days to see when they last logged in.

Reply
0 Kudos
jason2727
Contributor
Contributor
‎03-04-2015 10:21 AM

Right I understood it was a SQL query on the backend.

I am more looking to see not a particular user though.  I wanted to see if  it were possible to point out all VMs that had a last log in of 90 days or over for house cleaning.

Reply
0 Kudos