Page History

...

The 4 columns returned above (avg_capacity_in/out, max_capacity_in/out) need to be inserted manually into report_utilization table (very carefully). Make sure to match the absid , year and month.

To find the correct circuits to update use the below query:

select * from delete from reports.report_utilization a where year = 2018 and month = 8
and a
where (report_utilization.service_type='LMD')
and AND (a.base_absid = 24091 or a.base_absid = 24241 or a.base_absid = 24147 or a.base_absid = 22211 or a.base_absid = 44051 or a.base_absid = 24167 or a.base_absid = 41759 or a.base_absid = 42367
or a.base_absid = 27069 or a.base_absid = 36741 or a.base_absid = 28565 or a.base_absid = 19095 or a.base_absid = 37917 or a.base_absid = 24193 or a.base_absid = 23603
or a.base_absid = 23661 or a.base_absid = 43729 or a.base_absid = 34043 or a.base_absid = 34041 or a.base_absid = 5765 or a.base_absid = 40143 or a.base_absid = 40435) order by base_absidreport_utilization.year="2018")
AND (report_utilization.month="12")
and base_absid in (24091 ,24241 ,24147 ,22211 ,24167 ,41759 ,42367
,27069 ,36741 ,28565 ,19095 ,37917 ,24193 ,23603
,23661 ,43729 ,34043 ,34041 ,5765 ,40143 ,40435);