Chat now with support
Chat with Support

Enterprise Reporter 3.2.1 - Installation and Deployment Guide

Product Overview Installation Considerations for Enterprise Reporter Installing and Configuring Enterprise Reporter Managing Your Enterprise Reporter Deployment Troubleshooting Issues with Enterprise Reporter Appendix: Database Content Wizard Appendix: Encryption Key Manager Appendix: Log Viewer

Exporting Logs from the Configuration Manager

Exporting Discovery Management Logs

Discovery logs can be used to troubleshoot issues with discoveries. Discovery logs are collected from the Reporter server and all of the nodes within a selected cluster, and zipped into files that can be sent to Quest Support to help resolve certain collection problems. The discovery log files are all sent to the Exported Logs folder on the Reporter server. You may have several different .zip files, which may take some time to appear, depending on your configuration:

•
A ServerLogs.zip file containing the logs from the server.
•
A <Computer Name>_NodeLog.zip file for each node in the cluster.
To export discovery logs
1
On the Manage Discoveries pane, select a discovery.
By selecting a discovery first, the correct cluster for the discovery is automatically chosen.
2
Click the Manage Logs button and select Export Logs.
3
If necessary, change the selected cluster.
4
Click Export.
5
Click the link to locate your zip files.
Zip files are all located in the \ProgramData\Quest\Enterprise_Reporter\Exported_Logs folder.
You can now email your log files to your Quest Support representative.
6
Click Close.

 

* 
NOTE: To help diagnose issues, the ServerLogs.zip contains additional files including the DatabaseMaintenance.log file and a SQLLite file containing Enterprise Reporter system configuration information.
Exporting the Configuration Manager Logs

The Configuration Manager logs can be used to troubleshoot issues with the Configuration Manager service. Information is collected from the Configuration Manager service and is zipped into log files that can be sent to Quest Support to help resolve certain Configuration Manager problems. The log files are sent to the desktop on the Configuration Manager computer and may take some time to appear, depending on your configuration:

To export Configuration Manager logs
1
Click System | Information.
2
Under Client Logging Information, click Export Configuration Manager logs.
3
Click Export.
4
Click the link to locate your zip file.
You can now email your log files to your Quest Support representative.
5
Click Close.
Viewing the Configuration Manager Logs

You can unzip and view the Configuration Manager logs using the Log Viewer.

To view the Configuration Manager logs
1
Click System | Information.
2
Under Log Viewer, click View logs to open the Log Viewer.

Viewing Information About Your Enterprise Reporter Configuration

Understanding your system setup can be useful when troubleshooting. You can use the System Information page to determine where your console, Reporter server and Reporter database are hosted, what port the server is using to communicate, your software version, and other similar information you may find helpful in resolving issues.

To view system information in the Configuration Manager
•
On the Navigation pane, click System | Information.

Viewing Errors and Statistics for Tasks

For each task of a discovery, you can view collection options, errors, and statistics. These may be helpful when you experience failed collections, data that does not match your expectations, or when working on performance issues. To display the collection options for a task, hold the mouse over any column of data for that task.


For more information, see the Viewing Errors and Viewing Statistics in the Quest Enterprise Reporter Configuration Manager User Guide in the Technical Documentation. 

 

Moving the Enterprise Reporter Database

The following summary outlines line how to move the Enterprise Reporter Database from one SQL Server® to another SQL Server®.

•
Backup the database on SQL Server®
•
Restore the database from a backup to the new SQL Server®
•
Connect Enterprise Reporter to the new database location
•
Verify that the database has been moved successfully

The following procedures assume that you have the following permissions:

•
SQL permissions to access SQL Server® Management Studio on both the current and new SQL Server® to backup and restore the SQL database
•
Windows account permissions to copy the database file from one server to another, and to stop and start services on the Enterprise Reporter server
To back up the Enterprise Reporter database (dbReporter) on SQL Server
1
Open Enterprise Reporter and stop all node services in the Configuration Manager.
2
On the Enterprise Reporter Server, stop the Quest Enterprise Reporter Server services (and the Quest Enterprise Reporter Node services if a node was deployed on the Enterprise Reporter server).
3
Start SQL Management Studio and connect to the SQL Server® where the dbReporter database resides.
4
Expand the database node.
5
Right-click on the dbReporter database and select Tasks | Back up.
6
In the Back Up Database dialog, note the location and name of the dbReporter database backup and click OK.
To restore the Enterprise Reporter database (dbReporter) from a backup to the new SQL Server
1
Copy the .BAK file(s) to the new SQL Server®.
2
Start SQL Management Studio on the new SQL Server®.
3
Right-click on the database’s node and select Restore Database.
4
Under Source, select Device, click the ellipsis (…).
5
Click Add and browse to the backup copies.
6
Click Add, select the .BAK file, and click OK twice.
7
Under Backup sets to restore, select Restore beside the backup name.
8
From the Restore database window, click OK to restore the database.
To connect Enterprise Reporter to the new Database location
1
On the Enterprise Reporter server, stop the Quest Enterprise Reporter Server (and the Quest Enterprise Reporter Node if a node was deployed on the Enterprise Reporter server).
2
You may have more than one node deployed, so be sure to stop all node services.
3
On the Enterprise Reporter server, select All Programs | Database Wizard.
4
Choose Select/Upgrade Database and click Next.
5
Browse to (or type in the name of) the new SQL Server® and make sure the Enterprise Reporter database name is correct (for example, dbReporter), and click Next.
6
Accept the defaults on the Security Groups screen and click Next.
7
Click OK on the Database Maintenance Wizard popup that appears regarding replication.
8
Click Finish to initiate the database configuration.
9
Click OK upon completion.
10
Once you are returned to the Main Menu of the Database Wizard, click Close.
11
Start the Enterprise Reporter Server service.
12
Start all Enterprise Reporter node services.
To verify that the database has been moved successfully
1
Open Configuration Manager System | Information and confirm the database location.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating