Teh The Report Editor is a fantastic tool to create customized reports for audit data as well as for snapshot data. But you have to understand its basic logic and its settings. Otherwise you'll be trapped in trial and errors.

Reporting (general parameters)

Display Name

Image Removed

Defines the name of the report as it will appear in the Reporting selection box.

Image Removed

Regex Filter for Index selection

Image Removed

Defines the regular expression which is applied to find the elasticsearch index that is used as the base to the report. If you search for the elasticsearch indexes, that are generated by the audit driver or the snapshot service by default, you will find the following indexes using the browser based URL interface of elasticsearch:

Image Removed

In row index you see the two base indexes to use for reports:

• "audit-default-yyyy.mm.ss" created dialy by the audit driver
• "report-default-yyyy.mm.ss" created by the snapshot service each time it runs

"^audit" means select all indexes that do start with "audit". So in this example all available audit indexes will be used for the report.

Index Rename Javascript

Image Removed

This field represents a java script function, how the index name will be presented in the index selection list, when creating the report. The function sais take the name of the index starting with the 7th character and replae all "-" with a blank " ". So the real name of the index "audit-default-2022.05.10" will appear as "default-2022.05.10" in the selection list.

Image Removed

Sort Fieldname

Image Removed

Defines the attribute that is used to sort the report. The field does not to be set as a field on the report!

Sort Direction

Defines the sorting order ascending (asc) or descending (desc) for the sort fieldname defined above.

Image Removed

Fields (to retrieve data from)

Alias (and view options for field)

Filter (definitions)

Filter definitions let you filter the data for your report. BUT there are two completely differnet type of filters, that have a different purpose:

• hidden filters
• select filters 

Hidden Filters

Hidden filters do not show up in the filter selection when generating the report. So hidden filters have NO EFFECT on select filters even if you make select filters dependend on hidden filters!

Select Filters

Select filter types are:

• search
• select
• selectsearch
• selectperiod
• selectrange

Select filters are shown in the filter selection when generating the report. Only select filters you can make dependent on other select filters.

Please check the following section for instructions to the report editor.