Exporting MC-managed database messages and logs

You can export the contents of database messages, log details, query details, and MC user activity to a file.

You can export the contents of database messages, log details, query details, and MC user activity to a file.

Information comes directly from the MC interface. This means that if the last five minutes of vertica.log information displays on the interface, you can save that five minutes of data to a file, not the entire log. When you filter messages or logs, MC exports only the filtered results.

Depending on how you set your browser preferences, when you export messages you can view the output immediately or specify a location to save the file. System-generated file names include a timestamp for uniqueness.

The following table shows, by record type, the MC pages that contain content you can export, the name of the system-generated file, and what that file's output contains:

Message type Where you can export on MC System-generated filename Contents of exported file
All db-related message types Message Center page vertica-alerts-<timestamp>sv

Exports messages in the Message Center to a .csv file. Message contents are saved under the following headings:

  • Create time

  • Severity

  • Database

  • Summary (of message)

  • Description (more details)

MC log files Diagnostics page mconsole-<timestamp>.log

Exports MC log search results from MC to a ** .log file under the following headings:

  • Time

  • Type (message severity)

  • Component (such as TM, Txn, Recover, and so on)

  • Message

Vertica logs

Manage page

Double-click any node to get to the details and then click the VerticaLog tab

vertica-vertica-<db>-<timestamp>.log

Exports vertica log search results from MC to a .log file under the following headings:

  • Time

  • Type (message severity)

  • Component (such as TM, Txn, Recover, and so on)

  • Message

Agent logs

Manage page

Click any node to get to the details and then click the AgentTools Log tab.

vertica-agent-<db>-<timestamp>.log

Exports agent log search results from MC to a .log file under the following headings:

  • Time

  • Type (message severity)

  • Component (such as TM, Txn, Recover, and so on)

  • Message

Query details

Activity page

Click any query spike in the Queries graph to get to the Detail page.

vertica-querydetails-<db>-<timestamp>.dat

Exports query details for the database between <timestamp> and <timestamp> as a tab-delimited .dat file. Content is saved under the following headings:

  • Query type

  • Session ID

  • Node name

  • Started

  • Elapsed

  • User name

  • Request/Query

MC user activity

Diagnostics page

Click the Audit Log task

vertica_audit<timestamp>.csv

Exports MC user-activity results to a .csv file. Content is saved under the following headings:

  • Time

  • MC User

  • Resource

  • Target User

  • Client IP

  • Activity