Knowledgebase: WebRoot
Generating CSVs From Logs
Posted by Carlos R on 20 October 2016 08:21 PM

The Generated CSVs page lists in-process logs that are written to CSV files. The page includes CSV requests made from both the Monitors and the Logs tabs. The generated CSVs have these features:

  • Generated file size quota per account is 2 GB.
  • For Allowed, Blocked, File Types Blocked, Malware Blocked, and Full Audit, the generated CSV files can have up to two million lines.
  • For Monitors logs, the limit is 200,000 lines per CSV file.
  • The CSV files are compressed and stored for up to seven days.
  • The list of generated CSVs cannot be sorted.

To view the Generated CSVs page:

  1. From one of the Logs subtabs or the Monitors tab, specify filters and optionally change the Max Results value. Click Search to generate a log. Ensure that the search returns data.



  2. From the Logs tab, click the Scheduled Logs subtab.



    The page displays the status of the CSV generation process on a grid.




    The following table describes the information on the Generated CSVs view.
    Items on the Generated CSVs ViewDescription
    CSV Quota Information Displays:
    • The total file size of the generated CSVs
    • The file size quota for the entire account, 100 MB
    • The remaining available space for additional generated CSVs
    Create Data Displays the CSV file’s creation date and time based on the administrator’s time zone.
    Description If generated from Logs, displays the log type, for example, Blocked, Allowed, Audit Log, Full Audit, Malware Blocked, File Types Blocked, and so on.
    If generated from Monitors, displays Audit Log or Port Monitor.
    Conditions Displays the filters set for the returned data, for example, Group, Date, and other applicable filters.
    Status Displays one of the following statuses of the CSV generation process: Waiting to start, Processing, Completed (Link sent), or Failed to retrieve logs.
    Action Displays icons for deleting, downloading, and sending the email link to the file itself.
    • Deleting the file increases your file size quota.
    • Downloading the file provides you with a local copy of that file that you can send to an external application like MS Excel. The file continues to consume space on the log server.
    • Sending the email link to yourself enables you to view the file in the log server. The file continues to consume space on the server.
    Size Displays the generated file’s size and number of lines. The number of lines represent the number of data records in the file; to that number, add 1 for one header record. Therefore, four lines means the generated file contains four data records and one header record. The Quota Information box on the top left shows the total size of all files.


    After the CSV file is created, the status changes to Completed and the file size is indicated in the Size column. The number of lines correspond to the number of rows in the log.

    During the process, an icon for canceling appears in the Status column. Additional icons appear with the Completed status. If you move your mouse pointer over any icon, you see the text tip describing the icon.



     

     

    Note: The file size quota applies to your account. If multiple administrators request that CSVs be generated, the quota can be used quickly. CSV requests remain in the queue until you delete completed files or cancel those in process. You should therefore consider downloading completed files and then deleting them from the Management Portal to increase your available quota.


To delete a CSV file:

  1. Click the icon for deleting:


  2. Click Yes to confirm.
    The CSV is deleted from the list. Note that the file size quota increases by the size of the deleted file.
    The file remains in the log server until 2:00 a.m., when a process purges the deleted files.

To download the file:

  1. Click the icon for downloading:


    The browser prompts you for action on the file being downloaded. The prompt varies according to your browser.
  2. Respond to the prompts.
  3. Once the file is downloaded to your desktop, right-click and use the Open With command to open the file in another application, such as MS Excel.
Note: Microsoft Excel 2003 is limited to 64,000 lines and excludes lines beyond that limit. MS Office Excel has a 200,000 line limit.


To email the link to the file to yourself:

  1. Click the icon for sending the email.


    When the email reaches your inbox, the Status column displays the information.
  2. In your inbox, open the email with the subject CSV as requested.
    The body of the message displays the row on the Generated CSVs list for which the file was generated, and the link to the file.
    The email message includes icons next to the filters used for your searches, for example: Group, Date, URL, and others. Some email clients might not display these icons successfully, but this does not affect your ability to download CSV files through the email message.
  3. Click the link to access the file.
    This method does not delete the file from the server. The link expires after seven days, after which you receive an error message if you try to access the link. You must return to the Generated CSVs page to download the file.

ERROR: This domain name does not match domain registered in the license key file (cms.orlinpilot.com), allowed domains: support.excelmicro.com, please change the product path to match the domain under Admin CP > Settings > General Settings
This product will not work properly unless untill that value is changed.

For more information please contact Kayako support at https://my.kayako.com