Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Enterprise Reporter 3.5 - Report Manager User Guide

Table of Contents

Quest Enterprise Reporter Report Manager

Quest Enterprise Reporter Report Manager

Introducing the Report Manager

Starting the Report Manager Finding Answers and Getting Help An Overview of the Report Manager Security Explaining My Reports, Published Reports, and the Report Library

What are My Reports? What are Published Reports? What is the Report Library?

Reports Included in Enterprise Reporter

Active Directory Reports Azure Reports Computer Reports Enterprise Reporter System Reports Exchange Reports File Storage Analysis Reports

File Categories Folder Categories

Hybrid Reports Microsoft SQL Server Reports NTFS Reports Office 365 Reports Registry Reports Security Explorer Remediation Reports

Report Types Included in Enterprise Reporter

Active Directory Report Types Azure Active Directory Report Types Azure Resource Report Types Common Objects Report Types Computer Report Types Exchange Report Types Exchange Online Report Types File Storage Analysis Report Types Microsoft Teams Report Types NTFS Report Types OneDrive Report Types Registry Report Types SharePoint Online Report Types SQL Server Report Types

Configuring Global Settings (System Configuration)

Running and Scheduling Reports

Running Reports

Running Category Reports

Showing and Applying Category Report Parameters Change the Category Report View Navigating Within a Category Report

Running Regular Reports Running Reports or Exporting Reports to CSVand Other Formats from Different Containers Entering Parameter Values Searching for Parameter Values Importing Parameter Values Using Saved Parameters Searching for a Report Viewing Report Properties Previewing a Report Printing a Report Exporting a Report to Other Formats

Configuring a Default SMTP Server Scheduling Reports

Creating a Schedule

Delivering Scheduled Reports by Email

Types of Schedules

Run Your Schedule Once Run Your Schedule on a Daily Interval Run Your Schedule on Specified Days of the Week Run Your Schedule on a Specified Day of the Month Run Your Schedule Yearly

Working with Schedules

Adding Reports to a Schedule Editing Report Output Options on a Schedule Removing Reports from a Schedule Deleting a Schedule Running a Schedule Disabling or Enabling a Schedule Viewing Schedule History Transferring Ownership of Schedules

Troubleshooting Scheduling Issues

Using the Credential Manager

Changing passwords using the Credential Manager Changing account names using the Credential Manager

Organizing Reports

Working with Report Categories Moving Reports Copying Reports Deleting Reports

Creating and Editing Reports

Editing Reports

Using My Reports Changing the report icon Modifying the Fields to be Included

Performing Calculations Within a Report Indicating Data Age on a Report

Working with Report Parameters

What is a Parameter? Types of Parameters Parameter Operators Custom Query Data Types Working with Parameters

Changing the Layout Report Modification Example

Creating New Reports

Creating Report Layouts Setting CSV File Export Options Exporting and Importing Report Definitions

Report Designer Tips and Tricks

Report Bands Binding a Data Field to a Control Adding a Parameter Field to a Report Layout Adding a New Grouping to a Report Layout Adding a New Column to a Table Formatting Rules: Hiding or Showing a Field Based on Data Values Creating a Calculated Field Creating a Script to Run with a Report

Publishing Reports Integrating with SSRS

Configuring SSRS Publishing Reports to SSRS

Troubleshooting Issues with Enterprise Reporter

Troubleshooting connectivity issues

Restoring a connection to the Enterprise Reporter Server Restoring a connection to the Enterprise Reporter database

Troubleshooting Connection Timeouts Troubleshooting credential change failures Auditing Report Manager Activity Exporting Logs from the Report Manager Resolving Issues in the Report Manager

What To Do if the Data in Your Report is Not What You Expect Other Issues Viewing information about your Enterprise Reporter configuration

Troubleshooting Issues with SSRS

Appendix: PowerShell cmdlets

What is Microsoft Windows PowerShell? What are cmdlets? Registering Enterprise Reporter cmdlets Adding the snap-ins automatically to new sessions Enterprise Reporter cmdlets Enabling Enterprise Reporter cmdlets Loading the Enterprise Reporter cmdlets Using cmdlets to manage clusters and nodes

Creating a cluster Creating a node Disabling a node Enabling a node Finding a node by name Piping cmdlets Finding a cluster by name Disabling a cluster Enabling a cluster

Using cmdlets to manage discoveries

Getting job information Creating a job Running a job Scheduling a job Deleting a job

Using cmdlets to run reports

Connecting to the server Getting report information Exporting a report definition Importing a report definition to a category Generating a report with data

Starting the Enterprise Reporter Log Viewer Finding and opening log files Viewing and searching log file entries Filtering log file entries

Connecting to the server

Before you can use the report cmdlets, you must establish a connection to the Enterprise Reporter server. If you do not have your profile set up (see Loading the Enterprise Reporter cmdlets), you will need to establish a connection.

Connect-ERReportingServer [-Server] <String> [[-Port] <Int32>]

In this example, a connection is established to the AMERGEN01 server through port 7738.

Connect-ERReportingServer -Server AMERGEN01 -Port 7738

Getting report information

Report Manager has a report library that is broken into a logical folder structure with reports in each folder. The functional cmdlets require the ID and path associated with each report and not just the report name. To get the report ID and path, use the Get-ERReport cmdlet. You can use wildcard expressions with this cmdlet. The wildcard search is performed on the full report path including folder names and report name.

Get-ERReport [[-ReportName] <String>]

This example returns all information on the Domain Accounts report.

Get-ERReport "*\Active Directory\Domain Accounts*"

Id CategoryPath ReportName

-- ------------ ----------

58355095-75ee-4d21-9c11-1ccc15cbe3e3 Report Library\Active Directory Domain Accounts

This example returns all the reports that begin with Domain.

Get-ERReport "*\Active Directory\Domain*"

Id CategoryPath ReportName

-- ------------ ----------

58355095-75ee-4d21-9c11-1ccc15cbe3e3 Report Library\Active Directory Domain Accounts

e4067d44-b100-46e9-94da-8c3348584b50 Report Library\Active Directory Domain Computer Information

59143e6b-cf55-4aa7-b70c-69c2b5b61659 Report Library\Active Directory Domain Controller Information

584229c5-dc71-4107-a0e5-38a2a6d4b8de Report Library\Active Directory Domain Groups with Members

e6cf50aa-6078-4be8-aa92-3b0850264855 Report Library\Active Directory Domain Groups without Members

c49948e9-0337-47bd-bd48-e5cbf861391f Report Library\Active Directory Domain Groups

e4067d44-b100-46e9-94da-8c3348584b50 Report Library\Active Directory Domain Hidden Computers

237e4518-b843-4af7-911d-2b0ed62f1001 Report Library\Active Directory Domain Sites

92e8568c-850d-416a-8b2b-3b01ad0f1b43 Report Library\Active Directory Domain Summary

b41d8e07-d0f4-46da-a2ae-bdd96992a12b Report Library\Active Directory Domain Trusts

73d3a6b2-95d7-4690-9aad-3fdf39dac04e Report Library\Active Directory Domain Users with Recent Logons

73d3a6b2-95d7-4690-9aad-3fdf39dac04e Report Library\Active Directory Domain Users without Recent Logons

95ccdb73-b815-47d2-af98-bc359201b6cd Report Library\Active Directory Domain Users

Exporting a report definition

Reports in Report Manager can be modified and configured. The modified report can be exported to a designated location for disaster recovery or to share with others. The complete report information obtained from the Get-ERReport cmdlet is required when performing the export. For more information, see Getting report information.

Export-ERReportDefinition [-Report] <Report> [-Destination] <String>

In this example, the Get-ERReport cmdlet places the report information for a report in the Report Library into the $rpt variable. Next, the report definition is exported to the c:\ drive. The exported definition contains the report name and the report Id: Domain Users_95ccdb73-b815-47d2-af98-bc359201b6cd.xrd.

$rpt = Get-ERReport "Report Library\Active Directory\Domain Users"

Export-ERReportDefinition $rpt -Destination c:\

In this example, the Get-ERReport cmdlet places the report information for a report located in My Reports into the $rpt variable. Next, the report definition is exported to the c:\ drive. The exported definition contains the report name and the report Id: Domain Computer Information_e4067d44-b100-46e9-94da-8c3348584b50.xrd.

$rpt = Get-ERReport "My Reports\Domain Computer Information"

Export-ERReportDefinition $rpt -Destination c:\

Importing a report definition to a category

Reports in Report Manager can be modified and exported. The exported reports can later be imported into a new or existing category within the Enterprise Reporter report library.

Import-ERReport [-ReportPath] <String> [[-TargetCategory] <String>] [<CommonParameters>]

In this example, the report is imported to the default category My Reports.

Import-ERReport -ReportPath c:\Report.xrp

In this example, the report is imported to a category named My Reports\Imported.

Export-ERReportDefinition c:\Report.xrd -TargetCategory "My Reports\Imported"

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center