Quick query to show VMs that have not been logged into within the last 3 months. Adapted from this forum post.
SELECT VM_Name, UserName, [Host_Name], DataCenter_Name, MAX(Create_Time) FROM dbo.vpx_event WHERE EVENT_TYPE = 'vim.event.VmAcquiredMksTicketEvent' AND DATEDIFF(MONTH, Create_Time, GETDATE()) >= 3 GROUP BY VM_Name, UserName, [Host_Name], DataCenter_Name
One thought on “Last Login Date for VM”
Greaat read thank you