Report Generation – Continued

Generate On-Demand Report

While Scheduled Reports are recommended, where admin users create and automate report generation, there are cases where you might need an on-demand report. In such cases, regular users can create and generate reports as needed.

To generate an on-demand report, follow these steps:

• Click on the Generate Report button.
• Choose the Report Range (time range to generate the report) you’re interested in.
• Modify the Report Name if necessary.
• If dynamic filters are enabled in the template, select the values you need from the drop-down.
• The system displays all available columns from the table in a drop-down. Select the relevant fields.
• Pick the desired report format by checking the appropriate box.
• Toggle the Send Email radio button to include email addresses.
• Click the Generate button.
• The report gets generated in the background and will be displayed in the Generated Reports tab.

Generated Reports

All the generated reports will be displayed under the Generated Reports tab.

The following fields will be displayed.

• Report Name: Points to the Report Template used.
• Status: Indicates if the report is ready for download, failed, or in progress.
• Time Span: The timeframe of data in the report.
• Duration: Time taken to generate the report.
• Generated By: Information about the user who created the report.
• Generated Time: Timestamp of when the report was generated.
• Actions: Use the download buttons to save the report in the chosen formats.

In addition, there are other options available at the top of the table

1. Search Box: Users can locate a specific report by entering its name into the search box.
2. Add Filters: Users can perform searches by applying filters, including Report Name, Status, Time span, Filter Value, Duration ( in seconds), and Generated Time. Multiple filters can be applied simultaneously.
3. Refresh: You can click on this button to refresh the list of Generated Reports.

Report Tracking Information

If a report fails, you can access its tracking information by clicking on the Failed status. This helps diagnose the cause of the failure. For instance, if we need to investigate why the Report-Dashboard report has failed, we can click on the report to determine the cause.

Upon clicking the Failed status, a panel will appear, providing the tracked information for failed reports.

Download Reports

Click on the PDF or CSV button under the Action column to download the report. The report will be downloaded and saved to your local machine.

Annexure

Sample Query

All possible combinations are supported, including Joins, Aggregations, Renaming column names, Mathematical Operations, and Operators.

1. Longterm storage query:

• Query without dynamic filters:  select * from availabilitydata;
• Query with dynamic filters:  select * from availabilitydata where “host”=’$host’;

Time selectors are supported, which means if we want to fetch data only for a particular time range, we can do that by including “$start_time” and “$end_time” as the keyword, which will be replaced by the selected time filter.

• Query without dynamic filters and Time selector:  select * from availabilitydata where “creation_time”>=’$start_time’ and “creation_time”<=’$end_time’ ;
• Query with dynamic filters and Time selector: Select * from availabilitydata where “appid”=’$appid’ and “creation_time”>=’$start_time’ and “creation_time”<=’$end_time’

2.  Elasticsearch Queries:

1. Sample NOSQL DSL Query:

Here, the user needs to provide an index along with the query, multiple buckets like Date Histogram, Terms, Significant Terms, Data range, filters, etc., and multiple metrics like sum, count, average count, min, max, etc. aggregations are supported.

Query – {‘_source’: [‘alert_id’, ‘Alert-Rule-Name’, ‘alarm_state’], ‘size’: 100}

Index – vunet-1-1-notification-*

2. Sample NOSQL Timelion Query:

Here, the user needs to provide an elastic search query including the index and with a time field. Also, multiple buckets like Date Histogram, Terms, Significant Terms, Data range, filters, etc., and multiple metrics like sum, count, average count, min, max, etc. aggregations are supported.

.es(index=vunet-1-1-notification-*, q=*,size=10, timeseries=False)