Examples of Dynamic Templates Containing Functions
The best way to learn how to define functions in a report template is to learn by example.
The following list includes a sampling of the out-of-the-box reports that are shipped with the product, along with a few examples of the relevant information to help you isolate an example of the functionality that you are trying to implement.
To help you identify a field in the template that contains this functionality, the following convention is used in the list of report templates.
combines the values listed in the template. In the following example, the selected is , while the selected is .
Some templates are vendor product-specific, in which case you may have a Product:Alias such as EMC Avamar:A
Report Template | Report Type | Product: Alias | Caption | Field Type | Functions |
|---|---|---|---|---|---|
|
Reports | |||||
Backup Executive Summary | Table | All: F | Failed | Column | DECODE, SUM |
All: G | Failed Count | Hidden | DECODE, UNIQUE, COUNT | ||
All: U, All: V | Start Date | Hidden | MAX | ||
All: C | Total | COUNT | |||
All: D | Total | UNIQUE, COUNT | |||
Job Status Summary | Bar | All: T | Failure | Bar | DECODE, SUM |
Job Summary | Table | Veritas NetBackup: P1 | Client | Column | NVL |
Veritas NetBackup: O1 | Host Id | Hidden | NVL | ||
CommVault Simpana: X1 | Reason | Column | DECODE | ||
CommVault Simpana: R | Reason | Hidden | NVL | ||
Tivoli Storage Manager: C | Server | Column | UPPER | ||
HP Data Protector: V | Status | Column | NVL, DECODE | ||
Job Volume Summary | Bar | All: D | # of Files Backed Up or Restored | Line | SUM |
All: B | # of Jobs | Hidden | COUNT | ||
All: C | Backup/Restore Volume | Bar | SUM | ||
Job Duration | Bar | All: F | Job Duration | Bar | SUM |
Error Log Summary by Server | Table | All: E | Error Occurrences | Column | COUNT |
All: F | Last Error Date | Column | MAX | ||
Error Log Summary by Client | Table | All: F | Error Occurrences | Column | COUNT |
All: G | Last Error Date | Column | MAX | ||
Error Log Summary by Policy | Table | All: E | Error Occurrences | Column | COUNT |
All: F | Last Error Date | Column | MAX | ||
Consecutive Errors By Client | Table | All: N | # Consecutive Errors | Column | COUNT |
All: I | First Error Date | Column | MIN | ||
Largest Backup Volume | Pie | All: C | Job Size | Sector | SUM |
|
Data Domain Reports | |||||
Data Domain Snapshot History | Table | EMC Data Domain: K | Days Left To Expire | hidden | TRUNC |
EMC Data Domain: I | Expires After (Days) | Column | SIGN, DECODE, TO_CHAR, NVL | ||
|
Reports | |||||
Array Executive Summary | Table | All: A1 | Thin | Column | SUM, NVL |
LUN Utilization Summary | Table | All: F Hitachi Data Systems: C Symmetrix: D NetApp: E IBM: E IBM XIV: E IBM SVC: E HP EVA: C | Device Nbr | hidden | TO_CHAR, LPAD |
NetApp Cluster-Mode Volume Summary | Table | NetApp Cluster-Mode: N | Type | Column | UPPER |
EMC Isilon Nodes | Table | EMC Isilon: Y | # Int Up Interfaces | Column | DECODE, TO_NUMBER, SUM |
EMC Isilon: T | External IP Address | Column | DECODE, aptStringConcat | ||
EMC Isilon File System Performance by Protocol | Line | EMC Isilon: H | Max Bytes Out | Line | MAX |
EMC Isilon: A | # Active Clients | Line | AVG | ||