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.

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``>.csv`	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