Chat now with support
Chat with Support

Enterprise Reporter 3.5.1 - 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

Troubleshooting Scheduling Issues

If problems occur during the running of a schedule, an error indicator (a red dot) appears on the scheduled report card, along with an error message providing you with information to help you address the issue.

An error indicator on a schedule card indicates that one or more of the scheduled reports has an error. Resolve the issue, and then either wait until the next scheduled run, or manually run any needed reports by clicking Run this report on the scheduled report card, or run the schedule by clicking Run all reports belonging to this schedule on the schedule card.

You can also click the View History icon on the schedule card to see the last ten times the schedule ran and any corresponding errors. For more information, see Viewing Schedule History .

If you are running a report or have scheduled a report that will only output to CSV (no matter which format you select), this is likely a report that does not have a layout on the Layout tab of the report definition. For more information, see Creating Report Layouts .

If a report schedule runs and the report file gets created correctly, but the email has the following error,

this can indicate that the size of the report file exceeds the default maximum file size of 1MB for Enterprise Reporter email attachments. See Modifying the Maximum File Size for an Email Attachment for instructions on how to increase the maximum file size for email attachments.

Using the Credential Manager

Credentials are used in different places in Enterprise Reporter. For example, nodes and report schedules both use credentials. The Credential Manager is a 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.

Accounts are not verified when you add them, and they must already exist in order to be used by Enterprise Reporter. For each account, you can add a description. This is particularly useful for differentiating between similar accounts, such as similarly named service credentials, or your SQL Server® default "sa" accounts. The combination of the account name and the description must be unique.

Accounts with multi-factor authentication enabled need to be authenticated by Microsoft through the Credential Manager.

Credential passwords are encrypted with FIPS 140-2 compliant algorithms and an encryption key that has a user-supplied password. The encryption key is secured in the Windows Credential Manager (not to be confused with the Enterprise Reporter Credential Manager). The encryption key is used to encrypt all passwords that are used in Enterprise Reporter for collections and reporting. Additionally, Enterprise Reporter security groups and roles are used to validate who has access to the encryption key and the key cannot be retrieved without proper authorizations.

The Credential Manager will display a red key icon next to each account that requires a password.

See also:

2
2
Click Add.
If this is an Azure-enabled account, select the Azure Credential option. Once selected, click Authenticate to login and authenticate the account through Microsoft.
6
2
Click Add.
5
Click Authenticate.
7
Click Next.
9
Click Sign In.
11
Click Verify.
3
Click Edit.
6
3
Click Edit.
5
Click Authenticate.
7
Click Next.
9
Click Sign In.
11
Click Verify.
3
Click Authenticate.
5
Click Next.
7
Click Sign In.
9
Click Verify.
3
Click Delete.
4

Changing passwords using the Credential Manager

When passwords are changed in Active Directory and Azure Active Directory, they must be updated everywhere they are in use in Enterprise Reporter. It is possible that the account might be locked if you do not make this change. The Credential Manager makes this easy by providing a central store for accounts. You can change the password and it is updated in all nodes, schedules, discoveries, and so on.

If you modify credentials that are used by a discovery node, the node service must be restarted before the changes take effect. Enterprise Reporter will attempt to restart the node. However, if the restart fails, you may need to manually start the service on the computer that hosts the node. If there are jobs currently running on the node, they will be cancelled. To prevent this, either change the credentials during a down time, or cancel the discoveries yourself and restart them once the change takes effect.

Credential passwords are encrypted with FIPS 140-2 compliant algorithms and an encryption key that has a user-supplied password.

The Credential Manager will display a red key icon next to each account that requires a password.

3
Select Edit Password.
3
Select Edit Password.
5
Click Authenticate.
7
Click Next.
9
Click Sign In.
11
Click Verify.

Changing account names using the Credential Manager

In general, if you want to change an account name, it is recommended that you create a new credential, and delete the old one. However, in the case where you want to replace the credentials in use in a number of places in Enterprise Reporter, the Credential Manager enables you to make a single change and have it be applied across your deployment. For example, if you are provided a new service credential to replace a credential used for a dozen nodes in your environment, you can change the account name on the credential.

If you modify credentials that are used by a discovery node, the node service must be restarted before the changes take effect. Enterprise Reporter will attempt to restart the node. However, if the restart fails, you may need to manually start the service on the computer that hosts the node. If there are jobs currently running on the node, they will be cancelled. To prevent this, either change the credentials during a down time, or cancel the discoveries yourself and restart them once the change takes effect.

4
Click Authenticate.
6
Click Sign In.
8
Click Verify.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating