Page Comparison

• What is a PostprocessingIntroduction

• Report properties

• How to choose correct Index/Alias as data source

• Report properties

• Entities

• Filters

• Result Table Attributes

...

This is a complex report that has many entities, linkages, and all kinds of filters as well as enabled postprocessing. Let's start from "Report properties".

...

So, in this tab you can define "The Report ID", "Display Name", and "Description".

...

Tags can also be added. With tags you will be able to filter reports and put them into custom reports submenus.

...

One of the most important settings is "The Main index name".

...

Okay, the entity here, which will be used as the main one, can be defined only when you create at least one entity in the "Entities" tab. This main entity serves as the root of all reports.

...

"Default sort attribute" and "The Sort order - ascending or descending. Here you define the number of objects which will be displayed on the page. It's required for the pagination. And here you can enable or disable the "Show Flat result" option. You can learn more about this option in our previous videos.

For the setup of "The default time shift" are used the following values: days, weeks, months, and years. "Days" is set as a default time shift which will be applied to a date picker in the filtering stage. Here are "Round date-time value", "The default round date-time metric"  and "The Slice load". If you have a report that includes many secondary entities and you need to display a large number of attributes with long strings, as well as you have many post-processing functions to transform results, then you will benefit from using "The Slice load" option which increases performance and prevents the reporting system from crashing. With this option enabled, records will be loaded to the resulting table by bulks the size of which you define in the setting right next to this one. Moreover, you can also limit the size of data to be shown on the front-end, since some browsers don't process big sizes of data on front-end. Let's go to the second tab "Entities".

...

"Entities" is a powerful tool that allows you to link different objects not only from types of indices but also from different indices. For example, for snapshots from eDirectory and Active Directory to link data from snapshots with data from events, from events changes, and so on.

...

You can see that from the side of requests the "term" query is used, and the "regex" query is used to link secondary entities with the primary/main one. Additionally, the post-processing option is enabled to transform and parse values from the attribute you defined as a link. Let's go to "Filters."

...

In ACDI there is a plethora of basic filters. Let's go through all of them.

...

This is how the filters look when you run a report.

...

One of the filters is for the datetime strings. Let's see what a value for the attribute "nrfStartDate" looks like.

...

Here is a request from the History Browser found beforehand so you can check the value. You see here that it is a string with format year, month, date, hour, minutes, seconds, and time zone.

...

Hence, you need to select the "date_time" here and define a few settings, namely, "The DateTime Format Pattern" and "Type of DateTime field" – here it's either "date" or "date_string." The "Direction of dateTime shift" setting must be set to "last" or "next" and "Default time shift from now" is 7 days (set by default).

...

There is a nuance when using these filters: until you apply them, none of the objects will be affected. To apply a filter, you need to click an option, either from or to, and then click the "Apply" icon.

...

Let's now discard filters. To discard filters, you need to click the "Clear all" icon.

...

The other filter type is "autocomplete_search". This is a standard filter where you can enter any value and get results from which you can select the options you need.

...

The last filter type is the predefined one. You can find an example of this filter in the NetIQ Audit Driver Status report.

...

Choose using results from OpenSearch or the predefined values.

...

Then you select "predefined" here in this setting, and in the last filter setting you need to define a JSON array which will be used as a source for the predefined data.

...

It looks the same as a standard autocomplete search, but it will only have values you entered as the date source.

...

Now let's go through all the settings you can define for filters.

The first one is "Name of the Filter." You can see it in the label of a filter.

...

Here is also "ID of the Filter" which is displayed in the label of a filter, and you are able to find it in a Report Graph. It's used to link filters with entities. Make sure you keep it unique.

...

The third option is a selector for entities for which the filter "Entity filter belong to" will be applied.

...

"Data source name" - it's either a search from OpenSearch or the predefined data.

...

Here you define the data attribute name that will be used for filtering. Please take into account that this setting is case-sensitive. 

...

"The Attribute field type" setting is for attributes that have a string type. Here we have "keyword" by default. The difference between "field" and "keyword" is a type of search used to implement this filtering. More detailed information about this difference can be found in OpenSearch documentation.

...

"Sort Attribute." "The Sort order." Here are "Additional Attributes" which you may need later in post-processing.

...

In this setting you select the filter type: "autocomplete_search" or "date_time."

...

You see here switchers for multiple settings that define the behavior of your filter. The "Filter multiple selection" setting is responsible for the way how search will work in "start,"  "between," "end," or use the regular expression to match characters you enter in the search field.

...

Here you can enable the "Case-sensitive search" option. "Delay to start autocomplete search" refers to the delay between the time you start typing and the search process, a.k.a. actual search. The "Collapse result" has an impact on performance but take into account that it will work only for single value attributes. "Filter out all identical values," "Filter out all empty values," and the last option which will filter out entities that don't have the mandatory attributes you defined in "Entities."

...

This is a default behavior. Later, when you are in the filtering stage, you will be able to update these options from the web interface but your changes won't be saved for all reports. It will only work for one operation within the report.

...

The next one is behavior for multiple selection. This means that when you select two or more values, the operation will be executed with "or." However, if you have "and" selected in this setting, the search will try to find objects with multiple values matching your entries.

...

The "Size of records to fetch" setting refers to how many values you will have in the selector window.

...

Here you can select one of post-processing functions to transform the data in filters and enable or disable post-processing.

...

These four options are described in our previous video, in the chapter about the date&time filter. The last one is implemented only for the predefined filters. So, this is what the filtering stage looks like.

...

Let's go to the "Result Table Attributes."

Here you need to define a list of attributes to be displayed in the final report.

...

OK, here is the list of entities for the final report and its values.

...

Please take into account one small thing: for secondary entities to be displayed in the final report, you must add a special attribute for an entity and enable the "Use attribute for entity object" option using the switcher here.

...

With enabling this option, you will get a column with the alias name and all data for secondary entities, but it will be divided into different columns if you enable the flat format. Now let's go through all settings for "Result Table Attributes."

...

The first setting is "Name of the Attribute." Then it's followed by "The Entity Name" from which the attribute will be taken. Here you also see "The Alias name for the attribute" which will be displayed in the header of a column. Switcher for enabling "Use attribute for entity object. "Data source name" — currently there is only the "OpenSearch" option available. The "Hide from the result" option works by hiding this value from the results table, but it can be used later for post-processing if you need the values of this attribute to make some calculations and display the outcome based on the values of this attribute.

Here is the post-processing function switcher, and the option for "Pass full record object to the postprocess function." You can learn about post-processing in the respective video on the SKyPRO Academy page. "Field width" in pixels — here you define the minimum width of a column in the web interface in the report results table. There is also the "Achieve left side fixed columns by setting fixed property" option.

...

The last tab — post-processing — is described in one of our previous videos.

...

Thank you for your attention and take care.

Should you have any questions or require any assistance, please do not hesitate to contact us at any time swsupport.skypro@skypro.ch