Report to show recently added VM's to Orion (1 - 100 days) / SQL

Version 1

    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