max cpu use mhz by polling period

Question

first things first

i am new to this group and to orion vman

sure, i have been playing at it from time to time for more than a year, but now i am making a push to produce something with the data

i am trying to produce a stacked bar chart of mhz used by vm name prefix by time period

i had a little excel chart working, pulling data from VIM_VMStatistics_Detail (MaxCPUUsageMHZ) but data seems to go missing from day to day

I need a reliable source

any advice?

thanks

otto

lukas.vondruska · Answer

VIM_VMStatistics_Detail contains data only for last 7 days. Older data are rolled out to hourly and daily tables. Maybe you want to check VIM_VMStatistics view which does the union from all those 3 tables.