When was the last time user logged in

[galibai]

Hi, is there a way to find out when was the last time a user logged in his VDI VM?

We have VMs where in users have not logged in for a long time, and we want to delete them. but before we do that, we want to have some actual data to prove it.

My environment is 4.6

Thanks

[mittim12]

If you have an event database you can go back and review that for logs of the View environment.  

[galibai]

But going through logs and checking it against 150 VMs, is going ot be a big pain.

[mittim12]

The events database is stored in SQL so maybe there is an opportunity to use a SQL query to return only the information you need.

[galibai]

Do you know about any such queries that can help? 

[mittim12]

I don't have any in front of me but if I remember correctly the integrationg guide had some examples.

http://www.vmware.com/support/pubs/view_pubs.html