Versions Compared

Old Version 2

changes.mady.by.user Richard Sanigar

Saved on

compared with

New Version 3

changes.mady.by.user Richard Sanigar

Saved on

Key

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

...

** Pay attention to the year and month values in the Excel concatenate command

Copy the column that has the SQL statements and paste them into your favourite MYSQL tool and run the queries.

** There is a table within the reports database called SPLUNK_LINK, this links the IP Address of the results to the Circuit Name within OpsDB. This table could get out of date as Operations add more circuits.