Working with the Dynamic Template Designer > Examples of Dynamic Templates Containing Functions
  
Version 10.0.01
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.
• Product:Alias combines the values listed in the template. In the following example, the selected Product is All, while the selected Alias is F.
• 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
Storage Viewer for Backup 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
Storage Viewer for Capacity 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