Enterprise Reporter 3.5.1 - Report Manager User Guide

Changing the report icon

TYou can change the icon displayed in the header of reports. We recommend using an image that is 300 x 300 pixels. First, configure a global icon, then change the header icon on your reports.

NOTE: Reports that have custom layouts may need to have their layout adjusted to accommodate the custom icon. For more information, see Changing the Layout .

Modifying the Fields to be Included

You can add and remove fields from a report. Fields are organized by report type; a report can only contain fields from one report type. You cannot change the report type of a report. Each report type includes information from various related tables in the Reporter database. Some report types can be extended. By extending a report type, more fields are available to be added to your report. Typically, only a subset of the available fields are included in each report. You can add or remove fields to suit your needs.

NOTE: Each report may have a layout that defines how the fields are displayed, including the positioning, grouping and sorting. When you modify the included fields, the layout is not automatically updated. For information on modifying the layout, see Changing the Layout and Report Designer Tips and Tricks . You can implement some functions when choosing the fields, or when designing the report layout. For example, you can set sort ordering when you include the field in a report, or you can set it using the report layout. The difference between the two methods is where the action occurs. If you configure the fields, the action is carried out on the database before the report is generated. If you configure the report layout, the action is carried out as the report is generated. You might notice a performance increase if you configure the fields instead of the report layout.

By default, Enterprise Reporter collects a base set of attributes for each type of object. Your discovery administrator has the ability to extend some attributes in the Configuration Manager, and these are noted as (extended) after the field name in the Report Manager. They can be added to a report as usual, and you will find them in the report type associated with the object on which you are reporting. If you have requested that an attribute be collected, you need to restart your Report Manager in order to see the new fields in the report type.

You may also extend some report types to include additional fields for account objects. For example, in an NTFS report, you may want to see additional domain user fields that are collected by an Active Directory® discovery. You can accomplish this by adding account objects to the report type. The available types of account objects you can add are:

You may also extend some report types to include additional fields for identity objects. For example, in a OneDrive report, you may want to see additional Azure user fields that are collected by an Azure Active Directory discovery. You can accomplish this by adding identity objects to the report type. The available types of identity objects you can add are:

When editing a report, in the Available Fields area, the option to extend the report type is indicated by a special folder icon next to object names underlined in blue. You can right click the object names to see the available type of account or identity objects that can be added. For detailed steps on extending the report type, see To extend a report type .

You can set the sort order for each field on this page as well. This sorts the fields in the database before reporting them. Sort order is important in determining what the report output looks like. The first sorted field is the primary sort, the second field is the secondary sort and so on. For example, if you sort ascending on Server Name, Instance Name, and Database Name then arrange the fields in that order, your results are returned like this:

See also:

See also:

Performing Calculations Within a Report

You can also apply an aggregate to certain fields. Aggregates provide summaries of the available rows and columns of collected data in the Reporter database. Depending on the type of field you are working with, the available aggregates are:

Indicating Data Age on a Report

Data in your reports may be drawn from different discoveries (for more information, see Editing Reports ). This means that the freshness of your data may vary within a report. If it is important to understand when the data was collected, you can add this information to each top level object collected. The following table outlines where you can add this time stamp:

NOTE: If you want to know the last time a value changed, you can add the Timestamp field.