To create a table report template, click the New template button on the Sidebar. The template editor will be opened.
- Object of report
- The list of available fields
- The list of selected fields
- Condition builder
Every value retrieved by TNI 3 from remote assets can be displayed in a table report.
Selecting the object for your report
Start building the template by selecting one of the report object types.
Each single row of the resulting table report will correspond to a single object of the specified type.
A report can only be built for a single type of object. Selecting a new object will clear the list of selected fields. If you need to display fields from different types of objects (e.g. operating systems and RAM units), select Asset as the object, since it contains the fields of all the other objects.
Selecting fields for the report
When you've selected an object of report, its properties will be listed as Available fields.
Click one of the fields to select it. The circle next to its name will turn green, and the field will be added to the Selected fields list.
To delete a field from the template, click the X next to the field's name in the list of Selected fields or click the field in the list of Available fields once again. The circle will revert to gray.
Fields of the Asset object
This is the main object type, containing all the fields known to the program:
Fields of other objects
All types of objects beside Asset belong to a hypothetical asset. Therefore, attributes of the asset containing the object can be included in the report along with the fields of the object itself. Thus, the list of available fields is divided into two parts.
For example: you can build a list of monitors along with names and IP-addresses of assets that these monitors are connected to.
Filtering fields by asset types
Different types of assets have different sets of fields.
For example: the Operating system object for Windows-assets contains such specific fields as Service pack, Path to Windows directory, DirectX version, etc. Linux operating systems don't have these attributes, but they have Core version and Code name instead.
By default, the list of Available fields displays all fields of the chosen object, and icons of all types are highlighted in blue in the filter pane:
Click one of the icons to hide the fields specific to the corresponding type. Another click will display them again.
Some fields consist of several separate values.
For instance, the Image size of a monitor — e.g. "47 cm x 30 cm (22")" — is a combination of its Width, Height, Diagonal.
A complex field can be added as a whole, but you can add its elements independently as well.
To view the elements of a complex field, click the [+] button next to its name:
Type a field name into the search field to only display the matching fields and the groups that contain them.
Modifying selected fields
Each selected field corresponds to a column in the resulting report.
The order of the fields defines the order of the columns. You can reorder them by dragging them with your mouse (first select the field and then drag it).
To delete a field from the template, click the X next to the field's name in the list of Selected fields or click the field in the list of Available fields once again.
Click the [+] button to the left of the selected field's name or double-click the field to access its properties:
- Title: defines the name of the column. Full names of some fields are too long and inconvenient. You can change them to a more appropriate and shorter title in this field. Later you can revert the title back to the default by clicking the Restore icon on the right;
- Sorting: Use this to automatically sort the column in any direction;
- Fix column: A fixed column remains on the screen when you scroll the table horizontally. You may fix any number of columns;
- Hide column: hides the column from the report. You may still use values in it for sorting or for filtering using conditions (see below).
When the table report has been built, you can right click its header to hide or reveal columns via the context menu.
Conditions are used to filter the table rows based on the values from selected columns, or combinations thereof.
To add a condition, you first need to add some fields to the report and then create a simple or complex expression using the Condition builder.
To create the first expression, click Add condition.
An expression consists of a field, a type of comparison and, in most cases, a value. To build one, specify all the elements when prompted.
Different kinds of fields will provide different types of comparisons and values. Numeric fields can be compared with numeric values; strings can be matched against masks or other strings; some values can be selected in the list.
Creating complex expressions
A complex expression is a chain of simple expressions and logical operators: AND, OR, NOT.
To create a complex expression, first create a simple expression as described above. Buttons "And..." and "Or..." will appear below. Select one to chain in the second expression. A logical group of expressions will be formed.
To add another expression to the existing group, click the small (+) button below. After, click "And..."/"Or..." if you want to make it a part of a new logical group.
Keep adding expressions until you've built the desired condition.
In the Sidebar, templates with conditions are indicated by a small funnel icon overlay.
Don't forget to name your new template and press OK. The report will be automatically built and the template will appear in the Sidebar, to be used when needed.