Generating Audit Reports

You need to be an auditor to generate reports. See Setting the User As Auditor for details.

Audit reports provide the details of all the audited events that satisfy the various filtering criteria specified in the parameters. Reports can be generated using one of the following methods:


Generating Reports

Audit reports provide data of all the audited events. The audit data can be filtered using the criteria set based on target objects, filters, and dates. The objects on which the events are generated are called target objects.

  1. From the NAAS menu, click Reports.

    The Reports screen with options to enter target objects, filters, and dates is displayed.

    2.

  2. To filter audit data based on the target objects:

    1. Check Enable Filtering on Target Objects.

      2.

    2. Add the target objects required for report generation.

      3.

  3. To filter audit data based on filters, follow the steps given in Apply Filters during Report Generation.

    4.

  4. To filter audit data based on the dates:

    1. To get the audit data corresponding to the events on a specific date, check Enable Filtering on Start Date. Type the start date in the format yyyy-mm-dd hh:mm:ss.

      2.

    2. To get the audit data corresponding to the events generated till a specific date, Check Enable Filtering on End Date. Type the end date in the format yyyy-mm-dd hh:mm:ss.

      3.

  5. Click OK to filter the audit data based on the set criteria and generate the report.

    6.

After the report is generated, it can be saved as a .CSV file. This enables you to open the file in a spreadsheet application like Microsoft* Excel.


Executing Queries

  1. From the NAAS menu, click Query.

    The query screen is displayed.

    2.

  2. Type the SQL sub-clause for the statement SELECT * FROM NAAS_ADMIN.TRAIL WHERE (sub_clause).

    To generate reports based on IP address or MAC address of source machine, use the following query:

    • To filter based on IP address, enter the sub_clause as:

      SOURCE_IP LIKE 'IP ADDRESS%'

      •
    • To filter based on MAC address enter the sub_clause as

      SOURCE_IP LIKE '%MAC ADDRESS'

      •

    IMPORTANT:  The FDNs in the sub-clause should be entered in lowercase.

    3.

  3. Click OK to filter the audit data based on the specified query and generate the audit report.

    4.

After the report is generated, it can be saved as a .CSV file. This enables you to open the file in a spreadsheet application like Microsoft* Excel.



Previous | Next