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
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.