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 AWS, Alibaba Cloud, VMware, and Microsoft. I contribute to the IT community and I received VMware vExpert 2014 - 2019, vExpert Pro and VMware vExpert NSX 2017 Award.
My blog wojcieh.net - was voted #76 in Top vBlog 2018 contest!
Do what you love, and you’ll never work another day in your life.
Latest posts by Wojciech Marusiak (see all)
- Top vBlog 2018 is there! - 20 November, 2018
- Zentyal – my new Homelab Swiss Army Knife - 10 October, 2018
- Send VMware backups to the cloud – Altaro Offsite Copies to an Azure Cloud Storage - 18 September, 2018