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
- Scheduling Exported 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 master schedules and backup windows
- Add, edit, and move policies
- Add/Edit a threshold policy
- Capacity Chargeback policy types
- 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
- About Discovery types
- 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
- Analyze files
- Troubleshoot the Portal
- Retrieving log files
- Debug
- Attribute inheritance overrides
- Understanding report data caching
Dynamic Template Designer Overview
The Dynamic Template Designer is a tool that does not require Structured Query Language (SQL) knowledge in order to create custom report templates. You can easily assemble a simple report template by dragging and dropping fields into the template. The SQL database query is generated dynamically in the background, based on the configuration selections you make.
See Working with Enterprise Objects and Fields.
Another report template designer, the SQL Template Designer, is available for anyone with SQL knowledge.
The Dynamic Template Designer provides an inventory of
, such as Job, Data Domain, Host, Storage Array, and Amazon Web Services (AWS) objects, each designed for a specific type of data. The enterprise object is an abstraction of the physical implementation of the relationships of the collected data in the database.These enterprise objects provide the basis for creating and generating reports on collected data, to satisfy business use cases; for example, determining if your backup environment is providing sufficient data protection. Using the Dynamic Template Designer, you select an enterprise object as the starting point for your template. As you develop your template, you'll select fields and functions required to report on a specific enterprise object. You can assign a category which enables it to be grouped in the
. The Dynamic Template Designer also presents a variety of elements to help you design reports in the way that you'd like to view the data--as bar charts (in a variety of styles), donut charts, line charts, pie charts, or tables. In addition, you'll use this designer to define the elements required to select the scope of the data to be included in a report during report generation.The final output from the Dynamic Template Designer is a dynamic report template. There are two types of report templates: Dynamic Report Template (SQL knowledge not required) and SQL Report Template (SQL knowledge required for database query creation). A report template is the basis for all reports. When you generate a report, you start by selecting a report template and then selecting the scope of the data to be included in the report's output. Often, the terms report template and report are used interchangeably, but it is important to note that the report template is where the designer elements reside.
To become acquainted with the components and initial steps required to create a report template:
Review the Quick Start:
Read the Overview of Steps:
Learn by Example: View advanced capabilities that have been incorporated into existing, out-of-the-box reports:
Reference a Visual Overview: