How to genarare a report of Virtual Machine with Datastores/VMDK deatils

You have the interpretation of the report pretty wide open, perhaps you can let us know how you imagine the report would look, what columns do you expect to see, how do you want the storage disk mapping represented in the report. If we know more we can maybe direct you to a report that already exists.

Most of the time in the OOB reports for VMs there is a "related LUNs" report that allows you to drill down to the array.

I would also be interested in such a report.

There are DataStore reports and separate VM reports but now that match the two together.

What I could use is a combination of the 2 in order to use for vMotion migrations.

Something like:

ESXCluster->Datastore->StorageArray->VM's

That would help a migration effort and allow us to notify affected VM's based on each vMotion of a Datastore lun.

And examples or help in writing that code would be appreciated.

I'll post up the resulting code and report for others once complete.

Hello,

Sound strange but you would need to do it in two steps, expansion from VM to datastore and then datastore to VM. Like you would do to do mapping from VM to storage LUN.

Should looks like that:

With for VM expansion

• filter set to devtype=='VirtualMachine'
• expansion set to : device, deviceid

For Expansion VM to datastore

• no filter
• expansion set to: linkedto

For Expansion datastore to VM

• filter set to devtyp=='VirtualMachine' & parttype=='File'
• expansion set to: device

For Expansion on part

• no filter
• expansion set to: part

Regards,

JM

If you are looking at a report like below, you can use the attached report definition.

Hi Srini,

Have you reviewed the Path Details report for a VM, it has the information you are looking for.

Hope this helps.

-Gayatri