wassssssup peeps,
wanted to share a report to show you recently added virtual machines and there related host with a clickable node name links 

This SQL will query the the events table you might be limied to how many records you can retrieve depending on how long you keep your events. if you keep your events for a year your be able to use this report to all VMs added over a year if you really want just by changing the WHERE statement just change the number from 30 to what ever you want 

feel free to ask any question or improvements
simply import this report