this is my first issue I'm highlighting in this forum, so please apologize that I'm a newbie and not - yet! - a Netapp expert.
I'm managing capacity trends and calculate the amount of used space on volume level using volHistoryYearView.volEffectiveDataSpaceUsedSum to avoid the influence of deduplication.
This data is missing for the recent months for some controllers, while the aggregate histories are still filled.
To get the committed space I stay on aggregate level and get fine figures:
select objFullName,SUBSTR(timestamp,1,7) as month,max(ah.dfKBytesTotalCommittedSum/sampleCount) from aggrHistoryYearView ah join dfmgroup.objectView on ah.aggrId=objectView.objId inner join aggregateView a on a.aggrId = ah.aggrId where objFullName like 'MYFILER:MYAggregate' group by objFullName,month,aggrTotalCommittedSpaceKB order by month