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

Backing Up an Enterprise Reporter Database

The backup task allows the backup of configuration data (Cluster, Node, Discovery, and Report information) from an Enterprise Reporter SQL Server® database into a single SQLite database file. This backup file can be stored in case the main database needs to be re-created. Regular backups may help save time in the event of database loss or corruption of data.

* 
NOTE: Collected data is not included in the backup process.

To backup an Enterprise Reporter database, complete the following steps:

1
Define the source database information.
2
Define the backup database information.
To define the source database information
1
Click Backup.
2
Click Define source database information.
3
Enter the Source SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Source database name.
- OR -
Click the ellipsis to select a database from the specified Source SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To define the backup database information
1
After defining the source database information, click Define target database information.
2
Enter the full file path and file name for the backup file.
- OR -
Click the ellipsis to select a file location, enter a file name for the backup file, and click Save.
3
Enter a password.
* 
NOTE: The password will be used to encrypt the backup file and will be required to access the file during any restore process.
4
Confirm the password by entering it again.
5
Click OK.
6
Click Run.

Restoring an Enterprise Reporter Database

The restore task allows the restoration of configuration data (Cluster, Node, Discovery, and Report information) from the SQLite file created in the Enterprise Reporter Database Content Wizard backup task into a new Enterprise Reporter SQL Server® database of the same version. The new database must be created using the Quest™ Enterprise Reporter Database Wizard. For more information, see the chapter named Using the Database Wizard to Create or Connect a Database in the Quest Enterprise Reporter Installation and Deployment Guide in the Technical Documentation.

* 
NOTE: Collected data is not included in the restore process.

To restore an Enterprise Reporter database, complete the following steps:

1
Define the target database information.
2
Define the backup database information.
To define the target database information
1
Click Restore.
2
Click Define target database information.
3
Enter the Target SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Target database name.
- OR -
Click the ellipsis to select a database from the specified Target SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To define the backup database information
1
After defining the target database information, click Define backup database information.
2
Enter the full file path and file name of the existing backup file.
- OR -
Click the ellipsis to select the existing backup file and click Open.
3
Enter the password previously specified during the backup process.
4
Click OK.
5
Click Run.

Cleaning an Enterprise Reporter Database

The clean task allows the deletion of collected data from an Enterprise Reporter SQL Server® database. The clean task can be used to remove unwanted collected data if it becomes corrupt or inaccurate. You can delete all or each one of tombstoned, discovery run history, change history, and collected data.

* 
NOTE: Configuration data (such as Cluster and Node, Discovery, and Report information) is not included in the clean process.

Each type of data can be further filtered by the following options:

•
Discovery type: Active Directory, Azure Active Directory, Azure Resource, Computer, Exchange, Exchange Online, File Storage Analysis, Microsoft SQL, Microsoft Teams, NTFS, OneDrive, Registry
•
Collection date (before a specific date or older than a certain number of days).
To clean an Enterprise Reporter database
1
Select an existing configuration file to specify the source database and the clean options.
- OR -
Define the source database information.
2
Choose the cleaning options.
To select an existing configuration file
1
Click Clean.
2
Enter the full path and file name of the configuration file.
* 
NOTE: You can generate a configuration file using the steps in To choose the cleaning options .
- OR -
Click the ellipsis to select the existing configuration file and click Open.
To define the source database information
1
Click Clean.
2
Click Define source database information.
3
Enter the Source SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Source database name.
- OR -
Click the ellipsis to select a database from the specified Source SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To choose the cleaning options
1
After defining the source database information, click Choose cleaning options.
2
Select each type of data to be deleted during the clean.
3
Optionally, click Filter options for each selected data type and set the additional filters to apply.
4
Optionally, select Save these options in a file and enter the full path and file name of the file to create.
* 
NOTE: The file created by enabling this option can be used as a configuration file for subsequent or scheduled clean processes.
5
Once cleaning options are selected, click OK.
* 
NOTE: If you have selected Save these options in a file, that file is created now.
6
Click Run.

Merging Two Enterprise Reporter Databases

The merge task allows merging of collected data in a source Enterprise Reporter SQL Server® database into a target Enterprise Reporter SQL Server® database of the same version. The target database will contain data from both the source and target databases.

* 
NOTE: Configuration data (such as Cluster and Node, Discovery, and Report information) is not included in the merge process.
* 
CAUTION: It is strongly recommended that you back up your databases before starting the merge. You can restore the backup if there are issues with the merge.

To merge two Enterprise Reporter databases, complete the following steps:

1
Define the source database information.
2
Define the target database information.
To define the source database information
1
Click Merge.
2
Click Define source database information.
3
Enter the Source SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Source database name.
- OR -
Click the ellipsis to select a database from the specified Source SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To define the target database information
1
After defining the source database information, click Define target database information.
2
Enter the Target SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
3
Enter the Target database name.
- OR -
Click the ellipsis to select a database from the specified Target SQL Server.
4
Select an authentication method.
5
If SQL Server authentication was selected, enter the credentials.
6
Click OK.
7
Click Run.
A warning is displayed indicating that the data will be permanently merged and that this action is permanent.
8
Select I understand, and click OK.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating