Chat now with support
Chat with Support

Foglight for Databases 7.3.0 - User Guide

Getting Started Viewing, Acknowledging, and Clearing Alarms Viewing, Creating, and Managing Alarm Templates Monitoring Your Domains Monitoring Your Services Monitoring Your Hosts Reporting on Your Enterprise

Online-Only Topics

Online-Only Topics

Managing Reports

You can use the Manage Reports dashboard to download and view details about generated reports. If you have the Advanced Operator role, this is also the dashboard from which you perform report-management tasks.

Figure 69. The Manage Reports dashboard.

You can also use the Manage Reports dashboard to quickly generate and schedule new reports using an existing set of reports. From this dashboard you can run a report (see Online-Only Topics) and you can filter which reports are displayed in the table by selecting a template, module, or role.

If you have the Operator role, the Generated Reports table appears on this page. If you have the Advanced Operator role or Report Manager role, the Scheduled Reports table appears as well.

 
* 
TIP: Show or hide columns in the views using the dialog box that appears when you click the Customizer icon ().Quickly find a report in one of these views using the Search field. You can also click the Search menu to perform an advanced search or use regular expressions.
Filtering Reports

Filter the list of reports to find reports listed in the Generated Reports and Scheduled Reports views more easily. You can filter these lists to show only the reports associated with a particular template, module, or role.

To filter the list of reports:
1
On the navigation panel, under Homes, click Reports.
2
Click Manage Reports.
3
Click Currently Showing all Reports.
Figure 70. The Filter Reports dialog box appears.
4
Clear the Show All Reports check box.
5
Select the appropriate tab (Templates by Module, Templates by Role, or All Templates) based on whether you want to filter the lists to show only the reports associated with a particular template, module, or role.
 
* 
NOTE: If you selected the Templates by Module or Templates by Role tab: expand the items in the list to locate the template you want to use.
6
Select the template, module, or role based on which you want to filter the lists of reports.
Quest Foglight filters the lists of reports and automatically updates the filter link text to describe the current filter.
7
Close the dialog box when you have finished making your selection.
Managing Generated Reports

The reports that Quest Foglight has generated appear in the Generated Reports view. Use this view to download generated reports and to see details about a report such as its name, format, and the date on which it was generated. Report details are listed in the table and in the popup that appears when you click the row for a report.

 
* 
TIP: The icons in the table show you at a glance what type of report it is: the icon represents a one-time generated report and the icon represents an instance of a scheduled report.
Figure 71. The Generated Reports view.

To download and view a generated report:
1
Click the row for the report in the Generated Reports view.
A dialog box opens.
2
Click View () to start the process of saving or opening the report.
To delete a generated report:

If you have the Operator role, you can delete reports that you generated. If you have the Advanced Operator role, you can also delete reports that other users generated.

1
Use the check boxes to select the reports that you want to delete.
2
Click Delete ().
The Delete Generated Reports dialog box appears.
3
Confirm or cancel your selection in this dialog.
 
* 
TIP: If you have the Advanced Operator role, you can also delete generated instances of a scheduled report: click the row for the report in the Scheduled Reports view and then (in the popup) select the generated scheduled report from the Generated From Scheduled Report table and click Delete.
To schedule a generated report:

Use the Generated Reports view to create a scheduled version of a generated report. For example, you view a one-time report and decide it should be generated automatically at the end of each month.

You can also use this view to create a new scheduled report using a previously generated scheduled report. For example, you want to create a new scheduled report using the same template and the same schedule as your "End-ofDay" report, but the new report is tailored to a different service and emailed to a different group of recipients.

1
On the navigation panel, under Homes, click Reports.
2
Click Manage Reports.
3
In the Generated Reports table at the bottom of the view, click the name of the report you want to schedule.
4
Click Schedule.
The Scheduled Reports wizard opens.
5
From the first screen in the Scheduled Report wizard, set the following properties:
a
In the Name field, type a unique name for the report.
b
Choose the Output Format:
•
PDF is the default option.
•
Excel creates a report that you can open in Microsoft Excel.
•
XML creates a report in the XML format. Select this format if you want to import the data into other applications.
 
* 
NOTE: In certain cases, the XML output format contains more information than the other output formats. For example, the XML format can provide all the metric information for a given time range, whereas the Excel format only displays the current average value. This is because the Excel output is limited to what can be placed in a cell.
c
In the Retain field, type the number of instances of a scheduled report that you want Quest Foglight to keep. For example, if you type 3, Quest Foglight deletes the oldest instance of this report when it generates a fourth instance.
d
The Enable Scheduling check box is selected by default. When this option is selected, the scheduled report is automatically enabled when you click Finish.
•
Clear the check box if you want to disable the scheduled report for now. If you do so, Quest Foglight does not run the report on the schedule until you enable it manually.
e
Optional—type a comma-separated list of the email addresses of the recipients to whom you want Quest Foglight to email this report.
 
* 
NOTE: Your Administrator must configure Foglight to direct outgoing mail through your mail server before you can use this functionality. Contact your Administrator for details.
f
Click Next.
6
From the next screen in the Schedule Report wizard, set the input parameters to use for this report.
A description of the report template and a list the required and optional inputs appears.
a
Leave the report inputs as they are or tailor the report by specifying input values that meet your requirements.
b
To specify a value, click the Edit icon () next to the report input. The contents of the dialog that appears vary depending on the type of value that you are editing.
c
Click Next.
7
From the next page of the Schedule Report wizard, select a schedule.
 
* 
NOTE: If the schedules listed on this page do not meet your requirements, ask your Administrator to define a new schedule.
a
Select the schedule that determines when Quest Foglight runs the report. For example, choose End of day to run the report daily, at the end of each day (5:00 pm by default). Select a schedule from the list or click the Add icon to create your own schedule. If you have chosen to create your own schedule, select a schedule pattern type and enter the details.
 
* 
TIP: If you have a long list of schedules, use the Search field to narrow it down.
Start typing the schedule name into the Search field. You can also click the Search menu to perform an advanced search or use regular expressions.
b
Click Next.
The Summary is displayed.
8
Confirm if the report values are correct. If they are not, click Previous and make the appropriate changes. If they are correct, click Finish to save your scheduled report.
 
* 
NOTE: The report is automatically generated and displayed in a browser window. The report is also listed in the Scheduled Reports View on the Manage Reports dashboard.
To regenerate a report:
1
Click the row for the report in the Generated Reports view.
A popup appears.
2
Click Regenerate ().
The Run Report wizard appears.
3
Supply the values for the report input parameters. In the Optional or Required fields, click the Edit icon to select the new report input parameter value on which you want to base this report and then click Next.
4
Set the report properties.
a
In the Name field, type a unique name for the report.
b
Choose the Output Format:
•
PDF is the default option.
•
Excel creates a report that you can open in Microsoft Excel.
•
XML creates a report in the XML format. Select this format if you want to import the data into other applications.
 
* 
NOTE: In certain cases, the XML output format contains more information than the other output formats. For example, the XML format can provide all the metric information for a given time range, whereas the Excel format only displays the current average value. This is because the Excel output is limited to what can be placed in a cell.
c
Optional—if you want Quest Foglight to send this report to specific individuals, type a comma-separated list of email addresses of the required report recipients.
 
* 
NOTE: Your Administrator must configure Quest Foglight to direct outgoing mail through your mail server before you can use this functionality. Contact your Administrator for details.
d
Click Next.
The Report Summary appears.
5
Confirm if the report values are correct. If they are not, click Previous and make the appropriate changes. If they are correct, click Finish to generate your report.
The report is automatically generated and displayed in a browser window. The report is also listed in the Generated Reports View on the Manage Reports dashboard. See Managing Reports for information about using this dashboard.
Managing Scheduled Reports

When you schedule a report, it appears in the Scheduled Reports view on the Manage Reports dashboard. Use this view to download a generated scheduled report to see details such as its name, the schedule and template on which it is based, and the user who created it. You can also view report details in the popup that appears when you click the row for a report, such as the recipients to whom Quest Foglight emails the report.

Figure 72. The Scheduled Reports table.

Use the Scheduled Reports table to:

•
View generated instances of a scheduled report. See Viewing a Generated Scheduled Report for details.
•
Delete scheduled reports. For example, you no longer require a specific scheduled report because you deleted the service to which the report is tailored. See Deleting a Scheduled Report for details.
•
Enable or disable scheduled reports. For example, you are performing system maintenance and do not want Quest Foglight to run scheduled reports during that time. See Disabling or Enabling a Scheduled Report for details.
•
Copy or edit scheduled reports. For example, you want to create a second scheduled report that is based on the same template and uses the same schedule as another report, but is tailored to a different service and emailed to a different group of recipients. See Copying and Editing a Scheduled Report for details.
Viewing a Generated Scheduled Report

You can select a previous scheduled report to view or download it.

To download an instance of a scheduled report:
1
Click the row for the report in the Scheduled Reports view.
A popup appears.
2
In the Generated From Scheduled Report table, click a generated report in the Date column and click View to start the process of saving or opening the report.
Deleting a Scheduled Report

When you delete a scheduled report, you also have the option to delete any generated reports that are associated with it.

To delete a scheduled report:
1
In the Manage Reports dashboard, Generated Reports table, use the check boxes to select the reports you want to delete.
2
Click Delete.
A confirmation dialog box appears.
3
Optional — In the confirmation dialog, select the Delete related Generated Reports check box if you want to delete generated instances of this scheduled report. Once selected, click Delete.
Quest Foglight removes the report from the list of scheduled reports. If you selected Delete related Generated Reports, all generated instances of this scheduled report are removed from the list of generated reports.
Disabling or Enabling a Scheduled Report

When you create a scheduled report, you choose whether you want it to be enabled (runs automatically at the scheduled times) or disabled (does not run at the scheduled times until it is enabled).

You can change these settings at any time from the Scheduled Reports view.

To enable or disable a scheduled report:
1
Use the check boxes to select a report.
2
Click Manage.
A menu appears.
3
Click Enable or Disable.
If you click Enable, the value in the Enabled column changes to true.
If you click Disable, the value in the Enabled column changes to false.
Copying and Editing a Scheduled Report

You can create a new scheduled report by copying or editing an existing scheduled report.

To copy or edit a scheduled report:
1
On the navigation panel, under Homes, click Reports.
2
Click Manage Reports.
3
In the Scheduled Reports table at the top of the view, click one of the following icons:
•
The copy icon () in the row for the scheduled report that you want to copy.
•
The edit icon () in the row for the scheduled report you want to edit.
The Schedule Report wizard appears.
4
From the first screen in the Schedule Report wizard, set the following properties:
a
In the Name field, type a unique name for the report.
b
Choose the Output Format:
•
PDF is the default option.
•
Excel creates a report that you can open in Microsoft Excel.
•
XML creates a report in the XML format. Select this format if you want to import the data into other applications.
 
* 
NOTE: In certain cases, the XML output format contains more information than the other output formats. For example, the XML format can provide all the metric information for a given time range, whereas the Excel format only displays the current average value. This is because the Excel output is limited to what can be placed in a cell.
c
In the Retain field, type the number of instances of a scheduled report that you want Quest Foglight to keep. For example, if you type 3, Quest Foglight deletes the oldest instance of this report when it generates a fourth instance.
d
The Enable Scheduling check box is selected by default. When this option is selected, the scheduled report is automatically enabled when you click Finish.
•
Clear the check box if you want to disable the scheduled report for now. If you do so, Quest Foglight does not run the report on the schedule until you enable it manually.
e
Optional—type a comma-separated list of the email addresses of the recipients to whom you want Quest Foglight to email this report.
 
* 
NOTE: Your Administrator must configure Foglight to direct outgoing mail through your mail server before you can use this functionality. Contact your Administrator for details.
f
Click Next.
5
From the next screen in the Schedule Report wizard, set the input parameters to use for this report.
A description of the report template and a list the required and optional inputs appears.
a
Leave the report inputs as they are or tailor the report by specifying input values that meet your requirements.
b
To specify a value, click the Edit icon () next to the report input. The contents of the dialog that appears vary depending on the type of value that you are editing.
c
Click Next.
6
From the next page of the Schedule Report wizard, select a schedule.
 
* 
NOTE: If the schedules listed on this page do not meet your requirements, ask your Administrator to define a new schedule.
a
Select the schedule that determines when Quest Foglight runs the report. For example, choose End of day to run the report daily, at the end of each day (5:00 pm by default). Select a schedule from the list or click the add icon to create your own schedule. If you have chosen to create your own schedule, select a schedule pattern type and enter the details.
 
* 
TIP: If you have a long list of schedules, filter the list of templates by typing the first few letters of the template name or module in the Search field. You can also click the Search menu to perform an advanced or regular expression search.
b
Click Next.
The Summary is displayed.
7
Confirm if the report values are correct. If they are not, click Previous and make the appropriate changes. If they are correct, click Finish to save your scheduled report.
The report is automatically generated and displayed in a browser window. The report is also listed in the Scheduled Reports View on the Manage Reports dashboard. See Managing Reports for information about using this dashboard.
 
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating