How to connect vm_name with performance counters

[janekh]

Hi,

How to join VPX_HIST_STAT1 and VPX_VM tables in VCenter database, or how to join dbo.VPXV_HIST_STAT_DAILY and dbo.VPXV_VMS views?
I don't know how to connect vm_name with performance counters in VPX_HIST_STAT1 table.

[inleo]

you mean to make some kind of raport... you need SQL query?

[kszafer]

Hi

Thank You for Your email. I'm attending training till Friday. Please expect some delays in answering Your email.

Kindly Regards

Krzysztof Szafer

[janekh]

Hi,

I want to copy some performance data to other base. I need just simple SQL query: vm_name (or vm_ID), cpu_usage, memory_usage, timestamp. Intervals 5 minutes.