Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

VERSIONES DE PRUEBA GRATUITAS

Enterprise Reporter 3.6 - Report Manager User Guide

Navegación de contenido

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 Change History Reports Computer Reports Enterprise Reporter System Reports Exchange Reports File Storage Analysis Reports

File Categories Folder Categories

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

Report Types Included in Enterprise Reporter

Active Directory Report Types Microsoft Entra 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 Exporting a Report to Other Formats

Configuring a Default Email 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 credentials

Adding a credential Getting a credential Resetting a credential

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

Appendix: Log Viewer

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

Getting a credential

This cmdlet retrieves system credentials from the central store for accounts and passwords by unique identifier, an account name and description.

Get-ERSystemCredential [-Description <String>] [-AccountName] <String> [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]

Get-ERSystemCredential -CredentialId <Guid> [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]

In this example, the credentials for an account are returned. Note that the password is encrypted.

Get-ERSystemCredential -AccountName 'AMER\Administrator'

Resetting a credential

This cmdlet updates an existing system credential in the central store for accounts and passwords used throughout the system. This makes it easy to keep passwords up to date, and allows you to enter the credential details once, and access them repeatedly. This cmdlet will update NT Service accounts and restart NT Services if it has been used in a Node deployment or ER Server service.

Set-ERSystemCredential [-Credential] <PSCredential> [[-Timeout] <Int32>] [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]

The PowerShell cmdlet function Set-ERSystemCredential updates the system account password in the Enterprise Reporter credentials database and performs all required NTService changes (including node and server service restarts).

Connect-ERConfigurationServer hal-test-srv.AMER.hal.ca.qsft

$secpasswd = ConvertTo-SecureString 'pA$$w0d' -AsPlainText -Force

$credentials = New-Object System.Management.Automation.PSCredential ('AMER\Administrator', $secpasswd)
Set-ERSystemCredential $credentials

When updating ER Server credentials, the server will be restarted. This function completes before ER Server gets restarted. Before calling any additional configuration cmdlet, reconnect to the server using the following command:

Connect-ERConfigurationServer hal-test-srv.AMER.hal.ca.qsft


	NOTE: Timeout in seconds. This could be a time consuming operation and will stop in 10 min by default if it doesn’t receive responses from all nodes. If it is expected to take longer than 10 minutes to update all nodes, then include the –Timeout (in seconds) parameter.

Using cmdlets to manage clusters and nodes

The examples in this section deal with the basics of Enterprise Reporter, which are clusters and nodes for the clusters. Without nodes, clusters cannot direct any work to be done and without clusters, nodes cannot do any work.

This section contains the following examples:

•

Creating a cluster

•

Creating a node

•

Disabling a node

•

Enabling a node

•

Finding a node by name

•

•

Finding a cluster by name

•

Disabling a cluster

•

Enabling a cluster

Creating a cluster

The New-ERCluster cmdlet creates a new cluster in Enterprise Reporter Configuration Manager on which discoveries can be run. Nodes are associated with this cluster, which can be installed on systems in remote locations to allow jobs to run closer to the physical location.

New-ERCluster [-Name] <String> [[-Description] <String>] [[-SharedDataLocation] <String>] [[-ConnectionTimeout] <String>] [[-CommandTimeout] <String>]


	NOTE: The only parameter that is required is Name. All other variables can be added at a different time. Any parameter that contains a space must be enclosed in quotation marks.

In this example, the new cluster named Second Cluster is created.

New-ERCluster -Name "Second Cluster" -Description "This is a test description" –SharedDataLocation C:\Shared -ConnectionTimeout 100 -CommandTimeout 500

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación