Chat now with support
Chat with Support

Enterprise Reporter 3.5 - Report Manager User Guide

Quest Enterprise Reporter Report Manager Introducing the Report Manager Running and Scheduling Reports Creating and Editing Reports Troubleshooting Issues with Enterprise Reporter Appendix: PowerShell cmdlets

Running Reports or Exporting Reports to CSVand Other Formats from Different Containers

The procedure for running a report, exporting a report to a raw, unformatted CSV file, or exporting to other formats is the same, no matter what container the report is in. The Report Details view provides a breadcrumb trail to make it easy to navigate back through report categories and containers.

3
Click Run Report.
Click Export to CSV. For more information, see Setting CSV File Export Options .
Provide a name and location for the file, and click Save.
Click Yes to open the file or click No to return to your report.
Click Export to... For more information, see Exporting a Report to Other Formats .
Select a format for the resulting file.
Click Export Options, set the appropriate options, and click OK.
Provide a name and location for the file, and click Save.

Entering Parameter Values

When you run a report, parameter cards are used to filter the data and make your reports more meaningful. These parameter cards are added by the report author, who can be identified on the General tab of the Report Properties. For more information, see Types of Parameters . All parameters must have a green check mark icon beside them, satisfying the parameter requirements, before you can view the report.

Some parameters are required; you must enter values in these in order to run the report. The parameter type is indicated in the top right corner of the parameter card. Required parameters that you have not yet filled in are indicated by a red X icon. Once you have entered an acceptable value, a green check mark is displayed.

The action you take to enter a parameter value depends on both the type of operator and the type of field you are working with. For example, a field that contains numbers, combined with the Between operator, requires you to enter two values, one higher than the other. A field that contains a date and the Not in the last operator requires you to either type in or use the spin control to enter a number of days.

You can import parameter values from a file with one entry per line. You can merge the imported values with existing values or over-write the existing values. For more information, see Importing Parameter Values .

You can also save your favorite parameter values in the System Configuration tab with the Report Parameter Favorites option. When running or scheduling reports, you can then load the favorite parameter values you have configured.

You can choose whether to enter values in an optional parameter. Optional parameters have a green check mark icon regardless of whether a value is provided.

Include all permissions in the report (select the Include all results check box)

Once you have entered parameter values, they can be edited, deleted, or sorted. The height of the parameter window can also be expanded to make it easier to view and manage parameter values.

If you want to load parameter values from a text file with one entry per line, click the Import values from file icon, select the file and click Open. For more information, see Importing Parameter Values .
If favorite parameters have been configured, click Load Parameter Favorites under the Manage Parameters heading to the left of the parameter cards.
NOTE: You may configure your favorite parameter values in the System Configuration tab using the Report Parameter Favorites option.
3
2
Click Delete.
1
Once the parameter values have been added, click the Sort icon once to sort the values in ascending alphabetical order.
2
Optionally, click the Sort icon again to change to descending alphabetical order.

Searching for Parameter Values

In order to properly define your report, you must choose the values to include in your report. Enterprise Reporter helps with this task by providing a list of currently available values, based on the data that has been collected in your environment. By selecting from a list instead of typing in a value, you can be sure that data exists, and that you have entered the value correctly.

Because there can be large amounts of collected data available, you can search the collected database for the parameter value for any string field. You can enter search phrase, or use the * wildcard character to help narrow down the results. Only the first 500 results are returned; in this case, you need to provide a more refined search term.

When searching for parameter values, parameters will contain the option to display search results filtered by previous parameters when possible. For example, if you have already selected a domain for a report, then subsequent parameters will have the option to display only the results from that domain.

When a parameter is specific to selecting groups or users to be included in the report, when possible, the search results page will contain the option to Show only Groups or to Show only Users. Selecting either option will filter out all other objects thus making specific Groups or Users easier to find.

1
For any string parameter, click the Search icon or the Filtered Search icon.
If you have used the Filtered Search icon, the search results will be filtered based on the contents of previous parameters.
3
Optionally, select Show only Groups if it is available.
Optionally, select Show only Users if it is available.
5

Importing Parameter Values

You can create a text file of parameter values that you can later import into reports when running them. This option can be especially helpful when there are many parameter values to select every time you run a report or when there is a specific group of parameter values that is the same for every report you run.

The plain text file must have a file extension of .TXT and each parameter value must be on a separate line within the file. The following examples outline how you can import account names, computer names, and file or folder paths when running various reports.

When running a Domain Accounts report, you can import a file with account names. Each account name must be on a separate line and must be fully qualified as in the following examples.

HAL-TEST\Abby

HAL-TEST\Grace

HAL-TEST\Nevaeh

HAL-TEST\Brayden

HAL-TEST\PJ

HAL-TEST\Angela

When running a Computer Information report, you can import a file with the computer names for the computer parameter. Each computer name must be on a separate line and must be fully qualified as in the following examples.

HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT

HAL-TEST-SQL.HAL-TEST.DEV.HAL.CA.QSFT

HAL-TEST-DC.HAL-TEST.DEV.HAL.CA.QSFT

HAL-TEST-ITSS.HAL-TEST.DEV.HAL.CA.QSFT

HAL-TEST-EXCHG.HAL-TEST.DEV.HAL.CA.QSFT

HAL-TEST-NODE0.HAL-TEST.DEV.HAL.CA.QSFT

When running a Folder Permissions report, you can import a file with the specific paths for the path parameter. Each path must be on a separate line.

\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Financials Report.rtf

\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\HR\AMER\Payroll.rtf

\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\HR\EMEA\Employee List.rtf

\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Sales\Financials Report.rtf

\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Sales\Q3 Sales.rtf

\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Sales\Sales Graph.bmp

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating