Running built-in reports
This topic describes how to run built-in reports in the BMC Decision Support for Server Automation portal.
Before you begin
- Ensure that the first extract, transform, and load (ETL) run is complete before running reports. Use the BMC Decision Support for Server Automation Console to ensure that the ETL run has been completed before you run the reports. For more information, see Viewing the ETL status.
The first ETL run must finish before reports are run or you might have missing data errors.
- Run the KPI.Properties ETL to view the data in the reports:
nsh run_etl.nsh -s1 -f kpi.properties
To run a report
- Log on to the BMC Decision Support for Server Automation portal.
- Open the BladeLogic or BladeLogic KPI folder.
- Select the folder for the report group that contains the report you want to view.
For example, to run the Audit Summary By Policy report, select the Audit folder.
- Click the report that you want to run.
Depending upon the report type, multiple prompts appear.
- For each prompt, specify the value.
- Click Finish.
The report runs and results are displayed.
Considerations for built-in reports
The following conditions apply to the built-in reports:
- While running a built-in report, do not select more than 1000 values at a time in a prompt. If you do so, the following error message appears:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".ORA-01795: maximum number of expressions in a list is 1000 RSV-SRV-0042.
- When specifying options for scheduling reports, if you select Override the default values, the following values appear as choices in the Date Range field, but are not supported: Absolute Dates, Last Days, Last Months, and Last Years. If you select one of these date ranges, the report will not run. To avoid this issue, select other Date Range values or do not select Override the default values.
- If the HTML output of a report consists of multiple pages, a question mark character (?) is displayed instead of the current page number when you navigate to the last page of the report by using the Bottom link and then use the Page up link to view previous pages.
- BMC recommends that you do not modify built-in reports. Modification can result in corrupted reports. If you want to use modified version of a built-in report, such as adding more report filters, save the report with a different name in a folder other than BladeLogic. BMC does not guarantee that modified versions of built-in reports will work in future releases.
- Do not change the built-in report names in any language (reports are named in several languages). Report name changes are not supported and can result in corrupted reports.
- On a Mozilla web browser, when you run a report with Site Name as the value of the Site prompt, the report does not display any data even though data exists for all the sites in BMC Server Automation. Also, if you view data for one site, the report output is not formatted properly. Instead of Mozilla, use Microsoft Internet Explorer to view multisite data.
In some cases, the reports that you see at your site and the data that appears in reports is determined by the versions of BMC Decision Support for Server Automation and BMC Server Automation that are installed on your system.
When using HTTPS to access the BMC Decision Support for Server Automation portal, the built-in Job Activity reports do not display icons in the Job Run Status and Server Run Status columns. Therefore, the status of a job run cannot be determined when using HTTPS.