SQL query

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.

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 😉

Social Media

Wojciech Marusiak

Cloud Solution Architect at Microsoft
I am an innovative and experienced IT professional with over 13 years in the IT industry.

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.
Wojciech Marusiak
Social Media