Veritas NetBackup™ OpsCenter Administrator's Guide
- Overview of NetBackup OpsCenter
- About OpsCenter
- About OpsCenter components
- About starting the OpsCenter console
- About OpsCenter console components
- About the View pane
- Sizing the Content pane
- About using tables
- Installing OpsCenter
- About planning an OpsCenter installation
- Installing OpsCenter on Windows and UNIX
- About OpsCenter upgrade on Windows and UNIX
- About post-installation tasks
- About uninstalling OpsCenter on Windows and UNIX
- About clustering OpsCenter
- Getting started with OpsCenter
- Administering OpsCenter
- About the services and processes used by OpsCenter
- OpsCenter server scripts on Windows and UNIX
- About OpsCenter database administration
- About backup and restore of OpsCenter and OpsCenter Analytics
- About communication ports and firewall considerations in OpsCenter
- About OpsCenter log files
- Understanding OpsCenter settings
- Setting user preferences
- About managing licenses
- Configuring the data purge period on the OpsCenter Server
- Configuring SMTP server settings for OpsCenter
- Adding host aliases in OpsCenter
- Merging objects (hosts) in OpsCenter
- Modifying tape library information in OpsCenter
- Copying a user profile in OpsCenter
- Setting report export location in OpsCenter
- About managing Object Types in OpsCenter
- About managing OpsCenter users
- About adding AD / LDAP user groups in OpsCenter
- About managing recipients in OpsCenter
- About managing cost analysis and chargeback for OpsCenter Analytics
- Understanding data collection
- About configuring data collection for NetBackup
- About the Breakup Jobs option
- Viewing primary server details and data collection status
- About configuring data collection for NetBackup
- Managing OpsCenter views
- About OpsCenter views
- About managing OpsCenter views
- Managing static views
- Managing dynamic views
- View filters in OpsCenter
- Monitoring NetBackup using OpsCenter
- Controlling the scope of Monitor views
- About monitoring NetBackup using the Overview tab
- About monitoring NetBackup jobs
- Monitor > Services view
- About monitoring Audit Trails
- Managing NetBackup using OpsCenter
- About managing alert policies
- About creating (or changing) an alert policy
- About managing NetBackup storage
- About managing NetBackup devices
- About Operational Restore and Guided Recovery operations
- About Operational Restores from OpsCenter
- About Guided Recovery
- Troubleshooting Guided Recovery
- About managing NetBackup Hosts
- About managing NetBackup Deployment Analysis
- Data compilation for the Capacity License report
- Generating a Capacity Licensing report
- Supporting Replication Director in OpsCenter
- Understanding and configuring OpsCenter alerts
- About using SNMP
- About using SNMP
- Reporting in OpsCenter
- About OpsCenter reports
- Report Templates in OpsCenter
- About managing reports in OpsCenter
- Creating a custom report in OpsCenter
- About managing My Reports
- About managing My Dashboard
- About managing reports folders in OpsCenter
- About managing report schedules in OpsCenter
- About managing time schedules in OpsCenter
- Appendix A. Attributes of NetBackup data
- Appendix B. Man pages for CLIs
- Appendix C. Creating views using CSV, TSV, and XML files
- Appendix D. Error messages in OpsCenter
Creating an OpsCenter report using SQL query
This section provides the procedure to create a report using SQL query.
Only OpsCenter Analytics users can access the custom SQL query function.
See About custom SQL query in OpsCenter Analytics.
Note:
OpsCenter provides detailed information about the OpsCenter database schema that you may want to know before running any SQL query to generate reports. On the Report Wizard > SQL Query page, click the following link to open the PDF that contains all relevant information: Refer to the OpsCenter Database Schema Document
Note:
OpsCenter Reporter and Restore Operator do not have access to the custom SQL query option.
To create a report using SQL query
- In the OpsCenter console, click Reports.
- On the Report Templates tab, click Create New Report.
- On the Report Wizard, select the Create a report using SQL Query option and click Next.
- On the SQL Query page, enter an SQL query to view the required data.
For example, to view all NetBackup primary servers that monitored and managed by OpsCenter, enter the following SQL query: select * from domain_primarieserver
- Click Next.
You can view all primary server details that are stored in the domain_primarieserver database table.
Note:
When you run a stored procedure that has multiple result sets, then output of only the first result set is displayed on the GUI. The output of other result sets is not shown on the GUI.
Note that OpsCenter stores most of the time fields in Gregorian. If you want to see the value for a given Gregorian date field in a timezone that is configured on the OpsCenter host, you should use utcbiginttonomtime(gregorianDatefield) function, where gregorianDatefield is any time value in gregorian. The function utcbiginttonomtime function cannot consider DST time offset. Hence it ignores any DST offset while showing the date and time value.
You must not use utcbiginttoutctime() function as it does not show time in a time zone that is configured on your OpsCenter host.