Page History

...

Now, on prod-cacti01-fra-de.geant.net terminal connect to reports database on test-msr.geant.net:

Run the following commands:command on prod-cacti putty session in order to connect to reports database on test-msr host.

       mysql -ureportsUser -p -htest-msr.geant.net reports     ### Password for "reportsUser" user is on LastPass. Shared with Erik and Mark.

...

    6. delete from reports.infinera_dna_outages where event_sub_type != 'ALARM';

Close the MySQL connect (type exit).

We now need to populate a table called reports.infinera_outage_ci. :

...

Once the batch program has completed, log into the reports database (Heidi-SQL) with the reportsUser user and run the following commands2 queries:

1:

update reports.infinera_outage_ci
set time_diff = (UNIX_TIMESTAMP(end_time) - UNIX_TIMESTAMP(start_time))
where end_time is not null;

2:

SELECT CONCAT('UPDATE reports.report_service_availability SET outage = \'',TIME_FORMAT(SEC_TO_TIME(sum(a.time_diff)),'%H:%i:%s'),'\', number_of_failures = ',count(*),' WHERE base_absid = ',b.circuit_absid,' AND year = ',year(a.start_time),' AND month = ',month(a.start_time),';') as 'SQL Commands'

...