NetBackup IT Analytics User Guide
- Introduction
- Understand the Portal
- About the Admin tab
- Explore your inventory
- Hierarchy toolbar to organize your data
- Show objects
- Use attributes to organize your data
- Pin reports - saving reports with inventory objects
- Assign attributes in the inventory list view
- Get acquainted with reports
- About badging
- Generate and maintain reports
- Select Report Scope
- Group hosts by attributes
- Search for hosts in the report Scope Selector
- Backup Manager advanced scope selector settings
- Solution reports scope selector settings
- Units of Measure in Reports
- Customize report filter logic
- Sort columns in reports
- Convert tabular report to chart
- Distribute, share, schedule, and alert
- Schedule export of reports and dashboards
- Organize reports
- Work with the dynamic template designer
- Dynamic Template Designer Quick Start
- Converting to a Homogeneous, Product-Specific Template
- Dynamic Template Function Configurations
- Create Fields with the Field Builder
- Scope Selector Component - Custom Filter
- Configure a Bar Chart Dynamic Template
- Steps to Create a Bar Chart Dynamic Template
- Configure an Area/Stacked Area Chart Dynamic Template
- Line Charts for Performance Metrics
- Line Chart Field Requirements
- One Object Per Line Chart, One or More Metrics Per Chart
- Multiple Objects Per Line Chart, One Metric Per Chart
- Example of a Stacked Bar Chart Dynamic Template
- Create a Sparkline Chart in a Tabular Dynamic Template
- Adding or Editing Methods
- Validate and Save a Method
- Work with the SQL template designer
- Database Published Views
- Create a SQL Template
- Configure SQL Template Scope Selector Components
- Sample SQL Queries
- Configure SQL Template Scope Selector Components
- Format the SQL Template Output
- Configure a Table in the SQL Template Designer
- Advanced SQL Report Template Options
- Export/Import SQL Templates
- Pipelined functions for report query building
- APTlistOfDates
- aptStringConcat
- getServerAttributeValue
- getObjectAttributeValue
- getChildServerGroupContextById
- getServerGroupContextById
- secsToHoursMinSecs
- APTgetTapeDriveStatusName
- getFullPathname
- listJobSummaryAfterRestart
- listJobSummaryAfterRestartNBW
- listJobSummaryAfterRestart for NetWorker Backup Jobs
- listOfBackupWindowDates
- listChargebackCatByVOLSDetail
- listChargebackCatByNcVolDetail
- listChargebackCatByFSDetail (for HNAS)
- listChargebackCatByFSDetail (for EMC Isilon)
- listChargebackByLUNSummary
- listChargebackByLUNDetail
- listChargebackCatByLUNSummary
- listChargebackCatByLUNDetail
- Alert configuration
- Manage hosts, backup servers, and host groups
- Manage attributes and objects
- Provide Portal access and user privileges
- Setting / Resetting passwords
- Managing user group home pages (Administrator)
- Configure primary schedules and backup windows
- Add, edit, and move policies
- Solutions administration
- Manage and monitor data collection
- About data collection tasks
- Add/Edit Data Collectors
- Review collectors and collection status
- Upgrade Data Collectors
- Work with Capacity Manager host data collection
- Host Access Privileges, Sudo Commands, Ports, and WMI Proxy Requirements
- Host access requirements
- Manage credentials
- Configure host discovery policies to populate the host discovery and collection view
- Discovery processes
- Validate host connectivity
- Search and export in host discovery and collection
- Propagate probe settings: Copy probes, paste probes
- Discovery policies for Veritas NetBackup
- View and manage system notifications
- Customize with advanced parameters
- Use cases for advanced parameters
- Access control advanced parameters
- General Data Collection advanced parameters
- Cloud data collection advanced parameters
- Host discovery and collection advanced parameters
- Backup Manager advanced parameters
- Capacity Manager advanced parameters
- File Analytics advanced parameters
- Virtualization Manager advanced parameters
- Manage your Portal environment
- Manage ransomware scorecard
- Analyze files
- Troubleshoot the Portal
- Retrieving log files
- Debug
- Attribute inheritance overrides
- Understanding report data caching
To schedule an export of report or dashboard
If you are scheduling an export of a report or dashboard template, generate the report or dashboard. To schedule export of a saved report or a dashboard, skip to the next step.
See Generate reports.
See Save Cloud Reports.
Click
and select with the report/dashboard displayed.On the
dialog box, choose the format. The report type dictates the available export options. Not all export types are available for all report types.The following lists all potential options:
CSV(.csv). Exports data to a spreadsheet or a database application such as Microsoft Access.
Excel (.xlsx). Similar to the CSV export, this file supports MS Excel-specific features.
XML (.xml). Accesses the web page components.
Note:
XML is not available as an export type for dashboards.
PDF (.pdf). This read-only file lends itself to easy distribution and printing.
Text. A text file of the report/dashboard. This selection provides the option to set a delimiter and use quotes in the exported file.
HTML (.html). Exports this data as a web page, along with supporting files, in a zipped file.
Click
. When you schedule a report/dashboard to be exported on a regular basis, you must first configure a number of settings.Define the schedule. Use the following table to configure a schedule:
Action
Steps
Export
- Primary schedules can be configured and then applied to reports. Modifications to a primary schedule are applied to all reports associated with that schedule.
- Select 5, 15 or 30 minutes.
- Select 1, 2, 3, 4, 6, or 12 hours.
- . Select a specific run time.
:
. Check the day(s) on which the report will run.
. Select a specific run time.
:
. Select the day on which the report will run.
. Select a specific run time.
- Enter a CRON expression to fine tune the export schedule.
Export to the path*
Specify a sub-folder where the output will be saved. This sub-folder is relative to the default folder and it will be created if it does not already exist. If this field is left blank, the report will be saved in the base folder. The default base folder is set to:
Linux: /opt/aptare/export
Windows: C:\opt\aptare\export
For security reasons, the base folder for file exports is configured in the Portal under Admin > Advanced > System Configuration > Portal > Report > Report export path. Exporting to a network share requires that the share is already mounted on the Portal server and also configured in the Portal UI under Admin > Advanced > System Configuration > Portal > Report > Report export path. Note that this default base folder may have been changed by a Portal administrator.
The sub-folder name that you enter is appended to the base folder path and the report is saved with a filename that matches the report name. Invalid characters will be replaced by an underscore.
To create a unique filename that will not be overwritten, use variables: ${month}-${year}-${hour}-${minute}. This will create a file in the base folder with a name similar to: 12-2015-21-1.
To separate the filename from the folder, use double slashes, similar to: myfolder//JobSummary-12-2015-21-1.
FOR ADVANCED USERS: In some cases (for example, Managed Services Partners with hundreds of managed host groups), you may want to export to specific host group or report directories. Rather than configure each of these separately, use the following variables in the path specification to generate an individual report for each instance of the variable:
${hostGroup}
For example: /opt/aptare/export/${hostGroup}/doc
${reportName}
To overwrite/replace files each time the reports are exported, use the variables:
${day}, ${month}, ${year}, ${hour}, ${minute}
where the day, month, year, hour, and minute are represented as 2-digits, such as 02.
Run Status
Select
or . This selection enables or disables the schedule for the report or dashboard to be exported.Generate reports for
Choose one of the following:
- Creates a single report/dashboard based on the report's scope.
- Creates multiple reports/dashboards, based on the list that results from the Expression Builder.
Click OK. If you are scheduling export of a saved report, your configuration is saved. Instead, if you are scheduling export of a report or dashboard template, the Save Template as Report pop-up is displayed.
Enter the report name and select the folder (default /Home/My Reports) where the report instance can be saved.
Use New Folder to save the report instance in a new folder.
Click OK to save the export schedule.
Note:
If the exported report or dashboard contains a generic placeholder chart image, the chart export feature on your system has been disabled. See the Remove "PhantomJS" from NetBackup IT Analytics Portal tech note for further details.