Views:
Use the Log database to generate and view log statistics.
To generate, view, and export log statistics:
  1. Do one of the following to open the Log database:
    • From the ScanMail Configuration left menu, click Log Database.
    • Open smvlog.nsf.
  2. From the left menu of the Log database, click Statistics → Log Report.
  3. From the working area, select all statistics or a specific statistic to view.
  4. Select which tables to show from Show table(s):
    • All
    • Virus Scan
    • Message Filter
    • Attachment Filter
    • Content Filter
    • Script Filter
    • Spam Filter
    • Web Reputation
    • Outbreak Prevention Filter
    • Redirected Messages
  5. Select the Server(s) where the logs you want are located.
  6. Select a Range; All, Today, Last 7 days, Last 30 days, or Specific date.
  7. Click Calculate to begin compiling a summary report for the logs you selected.
  8. From the working area, click Export to export the raw data to a *.csv file.
    Note
    Note
    Use an electronic spreadsheet application (for example, Microsoft Excel™) to open *.csv files.

Using Microsoft Excel™ to View *.csv Exported Logs

Microsoft Excel displays the exported ScanMail logs in a more useful form.
To use Excel to view *.csv ScanMail exported logs:
  1. Open Microsoft Excel.
  2. Open the exported *.csv.
  3. Highlight the first column of data by clicking the column header.
  4. From the main menu, choose Data → Text to columns... and follow the Wizard that appears.
    • Select Delimited and then click Next.
    • Clear the Tab checkbox. Choose Comma, and then for the Text Qualifier, choose None.
    • Without making any changes in the last Wizard screen, click Finish.
  5. Save the document as an Excel file (*.xls) so you do not need to import and reformat again.
Keywords: statistics