Page History

...

Check your results by using the link: http://test-msr.geant.net:8888/msr/lambda_util.jsp

SINET circuits need to be removed. Use the below query and then remove them (base_absid = 33083 or a.base_absid = 33089)

select * from report_utilization where year = 2018 and month = 11 and service_type = 'lmd' and base_type = 'cct' ;

Now, run the below queries in order to obtain the (%) values. The results need to be inserted in the "report_utilization" table for the specific month and year:

...