janekh
Contributor
Contributor

How to connect vm_name with performance counters

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.

0 Kudos
3 Replies
inleo
Leadership
Leadership

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

http://blog.inleo.pl @maciejlelusz
0 Kudos
kszafer
Contributor
Contributor

Hi

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

Kindly Regards

Krzysztof Szafer

0 Kudos
janekh
Contributor
Contributor

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.

0 Kudos