View ocum_report_birt.aggregatecapacityutilizationhistory | Generated by SchemaSpy |
View Definition:
select `ocum`.`aggregatehistoryyear`.`aggregateId` AS `aggregateId`,`ocum`.`aggregatehistoryyear`.`periodEndTime` AS `periodEndTime`,`ocum`.`aggregatehistoryyear`.`dfKBytesUsedSum` AS `dfKBytesUsedSum` from `ocum`.`aggregatehistoryyear` where (cast(`ocum`.`aggregatehistoryyear`.`periodEndTime` as date) >= (now() - interval 13 month)) order by `ocum`.`aggregatehistoryyear`.`periodEndTime`