VMWare VMView - SQL Report - Reporting on when a VM was last logged into and by what ID
We have an environment of 4,000 VMs. Today I was asked to report on when a VM was last logged into and by which ID so we can determine which VMs haven't been used in at least 30 days so we can do cleanup of the environment (free up resources).
Does anyone by chance have a SQL Report that shows when VMs were last logged into and by which LAN ID?
I haven't had any experiencing reporting against the VMware databases. I'm more accustomed to doing SQL reports against the SCCM / configuration manager databases.