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 😉

Find when Virtual Machine was created using SQL query
Rate this post
Wojciech Marusiak
Social Media

Wojciech Marusiak

Solutions Architect at Alibaba Cloud
I am innovative and experienced VMware and Windows Server Engineer with over 10 years in the IT industry specializing in VMware virtualization and Microsoft Server environment.

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

Latest posts by Wojciech Marusiak (see all)