Versions Compared

Key

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

Connect to the reports database on test-msr.geant.net using the user reportsUser and the password that is stored in Keypass (Use MySQL Workbench)

Run the following query:

select * from reports.SPLUNK_DATA
where interface_description like '%VPN%'
and year = 2017
and month = 8
order by interface_description, year, month;

...