Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

7 = Maintenance End Time (UTC)

22 =  Related Services

Look at the title and value_text columns of the rows that have the field_id column of 22. You are looking for meaningful circuit names of IP Access, Interconnect, GEANT Lambda and GEANT Plus circuits.

Using OpsDB (http://opsdb.dante.net) obtain the circuit absid of the affected service detailed in the value_text column, of the resultset returned from the above query, when the field_id column is 27circuit

Create a spreadsheet and in column A put the circuit absid of the affected service, in column B put the Time as Epoch value when the field_id is 6 (Start Time) and in column C put the Time as Epoch value when the field_id is 7 (End Time).

...