How and when to choose Pivot View for creating custom report in EventLog Analyzer

How and when to choose Pivot View for creating custom report in EventLog Analyzer

Objective

 This article offers you the steps to create custom report as Pivot View in EventLog Analyzer. It will guide you through the process of generating custom report as Pivot View and offer a brief idea on when to use this option for your specific needs.

Prerequisites

  • Administrative role on the EventLog Analyzer user interface or Custom Report creation role.
  • Knowledge of the data sources and events you want to include in the report
  • Knowledge of what and when a pivot View option has to be selected.
Pivot view:
Pivot View is useful when you have to monitor particular values of the field based on which the report is generated. After selecting the report criteria, you can select the field and the values in the field that you want to monitor. Each of those values will be displayed as separate columns with the count.
This representation is used when you want a display a field corresponding to another based on count.

Steps to follow

Pivot View gives you a more granular representation of the log data. It allows you to select multiple criteria based on which data will be displayed. After framing the report criteria, you need to select the fields based on which Rows & Column has to be classified.
  1. Log in to EventLog Analyzer.
  2. Navigate to the "Reports" section.
  3. Click on Manage Report and Choose "+ Add New Report"
  4. Enter a name for your custom report and select the data sources you want to include.
  5. Click Report Group to add the new report to the desired group. The drop-down displays all available report groups under Custom Reports. Select one of these or create your own group and click '+'. If not specified, the custom report will be added to the Default Group.
  1. Select the Summary View in Report Type.
  2. Set the criteria for the report. You can add multiple criteria and perform AND or OR operations between them. You can also add criteria to groups and perform AND or OR operators between the groups.
  3. You can use the field values available in the application. You can extract custom fields as per your requirement, which can be used while creating a custom report. Refer how to extract custom fields in EventLog Analyzer to know more.
NOTE: The Pivot view data will be filtered based on the criteria that you have set here.
  1. Choose the Pivot Report Fields and build the structure based on which you want to create the summary.
    Process:
    1. Understand the use case of creating custom report and upon which value you want to get the count.
    2. Create the fields based on the order upon which you want it to be represented. Refer Sample use case for better understanding.
  1. Click Add to Save them
Sample Use Case: 
Example: "I want to know how many events are recorded in each device based on Severity"
In the above case, the requirement is that the user does not want to see the actual events, but just the count of events that are recorded by devices based on Severity
As number of devices may vary or can be higher, it is better to create the Row Field as Device and Column Field as Severity. You can also mentioned or select the Severity to be listed.
 
Results:

 Tips

  • Build the report criteria effectively to get the results to achieve the requirement achieved.
  • Regularly review and update your custom reports to ensure they meet your changing requirements.
  • Use Edit/Update option for the report customization options to tailor the report to your specific needs.
  • You can use Search tab to build the criteria easily for your custom report. Check out How to build criteria using Search for custom report in EventLog Analyzer to know more
 
 


      New to M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                      Related Products