How can i get a report with the creation date of all VMs in my VI3?

[Havi]

Hi all, i need a report of all my VM whit their creation date because i have to give a report related with the evolution of my vm farm.

Thanks a lot

[hicksj]

There is a "changeVersion" variable available under "config" (I see this when using viperltoolkit)... however, as the name implies, the timestamp changes whenever the VM config is updated.

Plus, have you gone through ESX2.5 -> 3 upgrades over the last year? Finding anything at the host level that maintains history on the VMs is probably pretty slim.

You may have better luck investigating the event logs on the individual guest operating systems, or looking through your change logs / work order management system for documented VM installs.

[masaki]

In this thread:

http://www.vmware.com/community/thread.jspa?messageID=391698&#391698

Two suggestions:

1) look at logs in VC

2) Find the same info in the VC database using dbviews.

[rrosenkoetter]

If your VMs are Windows servers in an Active Directory domain, you can write a script to get their creation date...

Set objComputer = GetObject(ADsPath)

wscript.echo objComputer.cn & vbTab & objComputer.whenCreated

where ADsPath is something like "LDAP://CN=ServerName,OU=Servers,DC=yourdomain,DC=com"

[masaki]

Look into the VPX_VM table and VPX_TASK.

Which records are there?

You can get them with a query..

select "field" from "table";

Message was edited by:

masaki

[wbednarzyk]

If your VM's are all Microsoft based, you can use a utility from Microsoft called eventcomb to comb through the event logs of all of the machines looking for a specific variable,

http://support.microsoft.com/kb/308471

Let me know if this was helpful. Bill