Extract Hardware report VMware

A quick and easy way to extract a hardware report with VMware

select
e.ID as VMID,
e.NAME,
--e.PARENT_ID as VMGROUPID,
--v.HOST_ID ,
v.RESOURCE_GROUP_ID,
v.MEM_SIZE_MB,
--v.MEMORY_RESERVATION,
--v.CPU_RESERVATION,
v.NUM_VCPU,
v.NUM_NIC,
v.IP_ADDRESS as [IP_ADDRESS_Virtual],
v.DESCRIPTION,
h.HOST_MODEL,
h.IP_ADDRESS as [IP_ADDRESS_Host],
h.DNS_NAME,
h.HOST_VENDOR,
h.CPU_MODEL,
h.CPU_COUNT,
h.CPU_CORE_COUNT,
h.CPU_HZ,
h.MEM_SIZE
from [VMWARE-VC].VPX_ENTITY e
Inner Join [VMWARE-VC].VPX_VM v On e.ID = v.ID
Inner Join [VMWARE-VC].VPX_Host h On v.HOST_ID = h.ID