Yesterday I was asked by my colleague if it is possible to find when virtual machine was created and by who. I found great post on Grzegorz blog. I tested it and it works from ESX 4.1 U3 up to ESXi 5.1
However it is possible to retrieve this information as well from vCenter database.
In order to find when Virtual Machine was created you can create simple SQL query in vCenter database and I will show you how to Find when Virtual Machine was created using SQL query.
In my case it is Windows SQL Server so I logged into SQL Management Studio and I executed following query.
select CREATE_TIME, USERNAME, VM_NAME, HOST_NAME, DATACENTER_NAME
Where VM_NAME = 'VIRTUAL MACHINE NAME'
order by CREATE_TIME;
After that I received information when it was created and who did it. Don’t forget to switch to vCenter Database at the beginning because you will execute query against Master Database 😉
My experience and skills have been proven by leading vendor certifications like VMware Certified Implementation Expert 6 – Data Center Virtualization, VMware Certified Advanced Professional 6 – Data Center Virtualization Design, VMware Certified Professional 6 - Data Center Virtualization, VMware Certified Professional 6 - Network Virtualization, AWS Certified Solutions Architect - Associate, ITIL V3, VMware vExpert 2014 - 2017 and VMware vExpert NSX 2017 Award.
My blog wojcieh.net - was voted #43 in Top vBlog 2017 contest!