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.
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.
All virtual desktops are assigned to individual users.
Does that help?
How are you querying the events data?
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.
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.