Search <book_title>...

APTARE IT Analytics User Guide

Last Published: 2021-06-01

Product(s): APTARE IT Analytics (10.5)

Introduction
1. Overview
2. Licensed modules
3. APTARE IT Analytics components
Understand the Portal
1. Overview
2. Portal access
3. Portal overview
4. Navigating with search
5. Valid entries for search
6. Search results view: Narrowing the scope
7. Filtering data in management grids
8. Advanced filtering
9. Customizing advanced filter logic
10. Saving advanced filters (Inventory)
11. Advanced filtering examples
12. Advanced filter operators
13. Clear advanced filters
14. Delete saved advanced filters
15. Select columns on management pages
16. Detect alerts in the inventory
17. About the Inventory tab
18. About the Reports tab
19. Reports tab keyboard shortcuts
20. Reports tab basics
21. Templates, reports, and dashboards overview
22. About the Alerts tab
23. About the Admin tab
  1. Users
  2. Domains
  3. Chargeback
  4. Solutions
  5. Data Collection
  6. Reports
  7. Advanced
Explore your inventory
1. Exploring your inventory
2. Inventory privileges
3. Getting started with the Inventory navigator
4. Hierarchy toolbar to organize your data
  1. Attribute value limitations
  2. Selection combinations
  3. Inventory object limits
5. Show objects
  1. Backup Servers in the Inventory
  2. Count Values
6. Reset inventory defaults
7. Host groups
8. Using attributes to organize your data
  1. System attributes
  2. Attribute value limitations
9. Use host groups to organize your data
10. Create custom object lists
11. Working with the inventory reports view
12. Accessing inventory reports
13. Choose reports to display
14. Filter within available reports by category
15. Pin reports - saving reports with inventory objects
  1. Renaming pinned tabs
  2. Resetting default report names on pinned tabs
16. Inventory reports and the action menu
17. Work with the inventory list view
18. Filter the inventory list view
19. Manage objects in the inventory list view
20. Assign attributes in the inventory list view
  1. About Attributes
  2. Attribute Limitations
21. Set attribute values in the inventory list view
22. Import host attribute values
23. Export objects from the inventory list view
24. Delete objects using the inventory list view
25. Customize columns in the inventory list view
Get acquainted with reports
1. Overview
2. Reports and templates
3. Cloud reports and templates
4. Report library
5. Report orientation
6. Shared reports and dashboards
7. About dashboards
8. Work in the Reports tab
9. New badge
10. About caching
11. Sections in the navigation panel
12. About badging
  1. Home section
  2. Cloud section
13. About the action bar
14. Reports tab keyboard shortcuts
15. Customizing your view panel
16. Folder types
17. Report template icons
18. Navigating through reports
Generate and maintain reports
1. Report Scope
2. Selecting Report Scope
  1. Time Period Considerations
3. Configuring Report Scope with Attributes
4. Group Hosts by Attributes
  1. Host Attributes Examples
  2. Find Hosts Without an Attribute Value Set
5. Searching for Hosts in the Report Scope Selector
  1. Finding Hosts Example
6. Alert Scope Selector Settings
7. Amazon Web Services (AWS) Scope Selector Settings
8. Backup Manager Scope Selector Settings
9. Backup Manager Advanced Scope Selector Settings
  1. Examples of Advanced Options Job Types
10. Capacity Manager Scope Selector Settings
11. Data Collection Status Details Scope Selector Settings
12. Host Scope Selector Settings
13. Solution Reports Scope Selector Settings
  1. Cascade to Sub-Domains
  2. Storage Optimization Scope Selector
  3. Risk Mitigation Scope Selector
14. System Health Check Scope Selector
15. Generating Reports
16. Generating Reports from the Cloud
17. Units of Measure in Reports
  1. Detail Reports
18. Advanced Filtering for Tabular Reports
19. Customizing Report Filter Logic
  1. Report Filter Operators
  2. Filtering Indicators, Multiple Expressions, Dates, Percentages, Yes/No
20. Sorting Columns in Reports
  1. To sort columns in a table report
21. Refreshing and Setting Refresh Intervals
22. Modifying Reports
23. Interact with Reports
24. Work with Topology
25. Adding a Note to a Backup Job Details Report
26. Using New and Updated User Report Templates
27. Using New and Updated System Report Templates (Super User Only)
28. Saving Reports
29. Saving Cloud Reports
30. Deleting Reports
Distribute, share, schedule, and alert
1. Exporting Reports and Dashboards
2. Known Limitations for Donut Charts
3. Scheduling Exported Reports and Dashboards
  1. To schedule an export of a report and dashboard
  2. Using the Expression Builder
4. Emailing Reports and Dashboards
5. Scheduling Emailed Reports and Dashboards
6. Viewing and Managing Your Scheduled Reports
7. Schedule Types
8. Deleting Scheduled Reports and Dashboards
9. Setting Up Alerts for Tabular Reports
10. Configuring an Alert
11. Deleting Report-Based Alerts
12. Share Reports, Dashboards, and Folders
13. Working with Shared Reports
Organize reports
1. Work with dashboards
2. Understand the dashboard Icons
3. About Cached Reports on Dashboards
4. Create new dashboards and add reports
5. Add reports to an existing dashboard
6. Save a dashboard with a different name
7. Edit the scope for a report on a dashboard
8. Expand a report to full size on a dashboard
9. Set the dashboard layout
10. Delete a dashboard
11. Remove reports from dashboards
12. Create a custom report folder
13. Create shortcuts to reports and templates
14. Manage My Home Pages
15. User Home Pages and User Group Home Pages
Work with the dynamic template designer
1. Dynamic Template Designer Overview
2. Dynamic Template Designer Cheat Sheet
3. Modify an Out-of-the-Box Dynamic Template
4. Dynamic Template Designer Quick Start
  1. Quick Start Step 1: Create a Basic Table Dynamic Template
  2. Quick Start Step 2: Format Fields
  3. Quick Start Step 3: Create a Calculated Field
  4. Quick Start Step 4: Configure Table Column Totals
  5. Quick Start Step 5: Define the Scope Selector
  6. Quick Start Step 6: Generate a Report and View the Automatically Generated Help
5. Steps to Create Dynamic Templates
6. Working with Enterprise Objects and Fields
7. Select an Enterprise Object
8. Configure General Dynamic Template Designer Components
9. Converting to a Homogeneous, Product-Specific Template
  1. Copy from All
10. Add Fields and Methods to a Dynamic Template
11. Alias Names for Fields
12. Conditions When Hidden Fields are Included by Default
13. Dynamic Template Field Configuration
14. Valid Formatter Patterns
15. Examples of Dynamic Templates Containing Graphics Tool Tips
16. Dynamic Template Drilldown Configuration
17. Custom Drilldowns and Examples
18. Drilldown Parameters
19. Examples of Dynamic Templates Containing Drilldowns
20. Using Groups in Dynamic Templates
21. Add a Group to Create Separate Line Charts in a Report
22. Add a Group to Create a Double Header in a Tabular Report
23. Dynamic Template Function Configurations
  1. Aggregation Functions
  2. Comparison Functions
  3. Numeric Functions
  4. Character Functions
  5. Date Functions
  6. Character String Returning Numeric Values
  7. Null Function
  8. Decode Function
  9. Unique Function
24. Examples of Dynamic Templates Containing Functions
25. Create User-Defined Fields with the Field Builder
26. Create Fields with the Field Builder
  1. Convert Dates to Numbers in the Field Builder
  2. Syntax for Calculated Fields
  3. Examples of Calculated Fields in a Dynamic Template
27. Configure a Static Filter
28. Filter on Date Fields
29. Static Filter vs. Tabular Report Filter
30. Configure the Field Sort Order
31. Return Unique Results
32. Dynamic Template Scope Selector Components
33. Scope Selector Component - Custom Filter
  1. Define a Custom Filter at Run Time
  2. Custom Filter Operators for Numeric Fields
  3. Custom Filter Operators for String Fields
34. Data Domain Enterprise Object Scope Selector Components
35. Host Enterprise Object Scope Selector Components
36. Job Enterprise Object Scope Selector Components
37. Storage Array Enterprise Object Scope Selector Components
38. Customize and Export Dynamic Templates
39. Exporting/Importing Dynamic Templates Containing Custom Attributes
40. Save a Dynamic Template After Edits
41. Format the Dynamic Template Output
42. Configure a Bar Chart Dynamic Template
  1. Best Practices
43. Steps to Create a Bar Chart Dynamic Template
  1. Bar Chart Dynamic Template: Use Case
  2. Bar Chart Dynamic Template Step 1: Create a Dynamic Template
  3. Bar Chart Dynamic Template Step 2: Configure Basic Field Functionality
  4. Bar Chart Dynamic Template Step 3: Configure Functions for a Field
  5. Bar Chart Dynamic Template Step 4: Configure Drilldowns for a Field
  6. Bar Chart Dynamic Template Step 5: Configure a Line Field
  7. Bar Chart Dynamic Template Step 6: Define the Scope Selector
  8. Bar Chart Dynamic Template Step 7: Save and Run the Report Template
44. Examples of Bar Chart Dynamic Templates
45. Configure an Area/Stacked Area Chart Dynamic Template
  1. Area/Stacked Area Chart Dynamic Template Step 1: Create a Dynamic Template
  2. Area/Stacked Area Chart Dynamic Template Step 2: Configure Basic Field Functionality
  3. Area/Stacked Area Chart Dynamic Template Step 3: Configure Functions for a Field
  4. Area/Stacked Area Chart Dynamic Template Step 4: Define the Scope Selector
  5. Area/Stacked Area Chart Dynamic Template Step 5: Save and Run the Report Template
46. Configure a Donut Chart Dynamic Template
47. Example of a Donut Chart Dynamic Template
48. Configure a Horizontal Bar Chart Dynamic Template
49. Example of a Horizontal Bar Chart Dynamic Template
50. Configure a Horizontal Stacked Bar Chart Dynamic Template
51. Example of a Horizontal Stacked Bar Chart Dynamic Template
52. Configure a Line Chart Dynamic Template
53. Line Charts for Performance Metrics
  1. Identify Array Performance Data Fields for a Template
  2. Rules and Guidelines for Performance Line Charts
54. Steps to Create a Line Chart Dynamic Template
55. Line Chart Field Requirements
  1. Line Chart: Caption Field
  2. Line Chart: Line Field
  3. Line Chart: Group by Object Field
  4. Line Chart: Hidden Field
  5. Line Chart: Exclude Field
56. One Object Per Line Chart, One or More Metrics Per Chart
  1. Configure One Object Per Line Chart
  2. Field Configuration for One Object Per Line Chart
  3. Scope Selector Configuration for One Object Per Line Chart
57. Multiple Objects Per Line Chart, One Metric Per Chart
  1. Field Configuration for Multiple Objects Per Line Chart, One Metric Per Chart
58. Format Line Chart Fields
59. Line Chart Scope Selections
60. Examples of Line Chart Dynamic Templates
61. Configure a Pie Chart Dynamic Template
62. Examples of Pie Chart Dynamic Templates
63. Configure a Stacked Bar Chart in a Dynamic Template
64. Example of a Stacked Bar Chart Dynamic Template
  1. Configure a Line in a Bar Chart
65. Configure a Table Dynamic Template
66. Examples of Tabular Dynamic Templates
67. Create a Sparkline Chart in a Tabular Dynamic Template
  1. Example of a Client Backup Sparkline Chart in a Dynamic Template
  2. Example of Using a Method to Create a Sparkline Chart in a Dynamic Template
  3. Client Failure Sparkline Method
68. Configure Chart Axes
69. Using Methods in Dynamic Templates
70. Overview of Method Creation
71. System Methods
72. Stand-Alone Methods
73. Viewing Methods
74. Adding or Editing Methods
  1. User-Defined Methods
  2. System Methods
  3. Accessing Methods
75. Tokens for Methods
76. Exception Tables for a Method's Join Clause
77. Validate and Save a Method
  1. Method Validation
78. Delete a Method
79. Troubleshooting Dynamic Templates
Work with the SQL template designer
1. SQL template designer overview
2. Database Published Views
  1. Access the Database Published Views from the CLI
  2. Access the Database Published Views from the SQL Template Designer
3. Steps to Create SQL Templates
4. Create a SQL Template
  1. Configure SQL Template Scope Selector Components
  2. Construct the SQL Query
  3. Help for Database Views
  4. Accessing the Published Database Views from the CLI
  5. Special Characters in SQL Queries
  6. Sample SQL Queries
5. Use Functions in Queries
6. Format the SQL Template Output
  1. Number, Size, Date, and Time Formatting
    1. Examples of Negative Value Formatting
    2. Status Icon Values
  2. Alignment, Aggregation, Bar Type, and Bar Type Color
    1. Configuring a Header and Footer in a Custom Report Template
  3. Area, Line or Column Sparkline Format for a SQL Tabular Report Template
7. Configure a Bar Chart SQL Template
8. Example of a Bar Chart SQL Template: Host CPU Performance
9. Configure a Line Chart SQL Template
10. Configure a Donut Chart SQL Template
11. Example of a Donut Chart SQL Template: NetBackup Job Size by Job Type
12. Configure a Gauge Chart SQL Template
13. Example of a Gauge Chart SQL Template: Allocated Capacity
14. Configure a Horizontal Bar Chart SQL Template
15. Example of a Horizontal Bar Chart SQL Template: Host CPU Performance
16. Configure a Horizontal Stacked Bar Chart SQL Template
17. Example of a Horizontal Stacked Bar Chart SQL Template: Available/Allocated Capacity
18. Configure an Area Chart SQL Template
19. Example of Area Chart SQL Template: Allocated Available
20. Configure a Pie Chart SQL Template
21. Example of a Pie Chart SQL Template: Overall Job Status Summary
22. Configure a Pivot Table SQL Template
23. Example of a Pivot Table SQL Template: NetBackup Job Size
24. Configure a Stacked Bar Chart SQL Template
25. Example of a Stacked Bar Chart SQL Template: Host CPU Performance
26. Configure a Table in the SQL Template Designer
  1. Example of a Table SQL Template: Host Group Membership List
  2. Example of a Table SQL Template: Exposed Clients
27. Save and Share Report Templates
28. Advanced SQL Report Template Options
  1. Creating Drilldowns
  2. Using SQL Templates for Drilldowns
  3. Create mouse-over hovers
  4. Add an External Reference
  5. Inventory Report Configuration
  6. About the Reports in the Inventory
  7. Edit a Custom Report Template
29. Export/Import SQL Templates
  1. Export a SQL Template
  2. Import a SQL Template
Pipelined functions for report query building
1. About Pipelined Functions
2. General Functions
3. APTlistOfDates
  1. Example Query
4. aptStringConcat
  1. Example Query
5. collectString
6. getLicenseClientDetail
7. getServerAttributeValue
  1. Example Query
8. getObjectAttributeValue
  1. Example Query
9. getChildServerGroupContextById
  1. Example Query
10. getServerGroupContextById
  1. Example Query
11. secsToHoursMinSecs
  1. Example Query
12. Backup Manager Functions
13. APTgetJobTypeName
14. APTgetTapeDriveStatusName
  1. Example Query
15. getFullPathname
  1. Example Query
16. listJobSummaryAfterRestart
  1. Example Query
17. listJobSummaryAfterRestartNBW
  1. Example Query
18. listJobSummaryAfterRestart for NetWorker Backup Jobs
  1. Example Query
19. listOfBackupWindowDates
  1. Explicitly Supply the Backup Windows
  2. Example Query
20. listOfBackupWindowDates (by Backup Window ID)
21. Policy Auditing Functions
22. listClientChanges
23. listPathnameChanges
24. listPolicyChanges
25. listScheduleChanges
26. Capacity Functions
27. listChargebackCatByVOLSDetail
  1. Example Query
28. listChargebackCatByNcVolDetail
29. Example Query
30. listChargebackCatByFSDetail
  1. Example Query
31. listChargebackCatByFSDetail
  1. Example Query
32. listChargebackByLUNSummary
  1. Example Query
33. listChargebackByLUNDetail
  1. Chargeback in Cluster and Virtualization Environments
  2. Example Query
34. listChargebackCatByLUNSummary
  1. Example Query
35. listChargebackCatByLUNDetail
  1. Example Query
Alert configuration
1. Overview
2. Alert rules
  1. Scheduled Rules vs. Run Time Rules
  2. Alert rules sample set
3. Managing alert policies
  1. Add/Edit an Alert Policy
  2. License Usage Alert Rule
4. ServiceNow: Job finalized alert rule
5. Managing alert notifications
  1. Adding an Alert Notification Delivery Method
  2. Deleting an Alert Notification Delivery Method
6. Report-Based alerts
7. Detect alerts in the inventory
8. Suppress alert notifications
  1. View suppressed alerts
Manage hosts, backup servers, and host groups
1. About hosts, backup servers, and host goups
2. Plan your host group hierarchy
3. Manage host groups
4. NetBackup Master Servers
  1. Configure the Time Zone for a NetBackup Master Server
  2. Default Host Group Hierarchy for Veritas NetBackup
5. About the Master Servers Group
6. Identifying Inactive Clients (For Veritas NetBackup)
7. Managing hosts and backup servers
Manage attributes and objects
1. About attributes
2. Attribute example
3. Host groups vs attributes
  1. When to use attributes (Preferred)
  2. When to use host groups
4. Bulk load utilities and attributes
5. System attributes
6. Attribute inheritance
7. Manage attributes
8. Set attributes on hosts
9. Add attributes
10. Edit or rename attributes
11. Delete attributes
12. Attribute naming rules
13. Examples of attributes and values
14. Understanding the attribute management view
15. Attribute management view (Top-Level domain)
16. Attribute management view (Sub-Domain)
17. Export / Import dynamic templates with custom attributes
18. Export a dynamic template that contains attributes
19. Import a dynamic template that contains attributes
20. About object maintenance
21. Product specific objects for reporting
22. Maintaining objects
23. Assign attributes using object maintenance
24. Search for objects by type in object maintenance
25. Customize library objects
26. Permanently remove devices, libraries, and drives
Provide Portal access and user privileges
1. Providing user access to the portal
2. Creating portal user accounts
3. About user types
4. Selecting user groups for users
5. Working with user groups
6. Creating user groups
7. Assigning users to user groups
8. About user privileges
9. Assigning user privileges
10. Setting user group privileges
11. Enabling new product report templates
12. Enabling cloud privileges
13. Granting access to template designers
14. Enabling all privileges in a category
15. Managing users and user groups
16. Searching for users and user groups
17. Editing user accounts
18. Impersonating user accounts
19. Setting / Resetting passwords
  1. Password notes
20. Account lockout
21. Managing user group home pages (Administrator)
  1. My Home pages and user group home pages (Administrator)
22. Removing portal users
23. Deactivating user accounts
Configure master schedules and backup windows
1. About master schedules
2. Configure master schedules
3. About custom backup windows
4. Custom backup window requirements
5. Configure custom backup windows
Add, edit, and move policies
1. Add/Edit a Cloud Policy to share performance statistics
2. Configure ommunity performance profiling
3. Add/Edit a threshold policy
  1. Threshold Example
4. Add/Edit a capacity billing and usage policy
5. Capacity Chargeback policy types
  1. Example of Capacity Billing and Usage Policy Logic
  2. Drive Types for Capacity Chargeback
6. Add/Edit a backup SLA policy
7. Add/Edit a SAN Fabric Chargeback policy
8. APTARE IT Analytics Billing and Chargeback policies
9. Add/Edit a Billing and Chargeback policy
Solutions administration
1. Storage Optimization solution overview
2. Understand the value of Storage Optimization historical data
3. Configure Storage Optimization rules
  1. Edit Storage Optimization Rule Example
  2. Common storage optimization parameters
4. Enable Storage Optimization rules
5. Storage optimization rule prerequisites and logic
6. Risk Mitigation solution overview
7. Configure Risk Mitigation rules
Manage and monitor data collection
1. Data collection overview
2. Data collection component configuration
3. About data collection tasks
  1. Backup collection tasks
  2. Backup event data collector
4. Data collection installation summary
5. Update the Local Hosts file for data collection
6. Data Collector security and data encryption
7. Manage Data Collectors and collection policies
8. About validation and status
9. Add/Edit data collectors
  1. Data Collector Encryption
10. Enable/Disable data collectors
11. Enable and disable data collection policy schedules
12. Review collectors and collection status
  1. Known Limitations for Policy States in Collector Administration
13. Deleting a data collector
14. Upgrade Data Collectors
  1. Upgrade aptare.jar
  2. Update Upgrade Manager
15. Monitoring data collection status
16. Organize the collection status view
17. Quick Filters
18. View data collection status
19. Troubleshoot data collection status
20. Use reports to monitor data collection status
Work with Capacity Manager host data collection
1. Understand the host data collection process
2. Host resources prerequisites and configurations
3. Host Access Privileges, Sudo Commands, Ports, and WMI Proxy Requirements
  1. Access Requirements by OS
4. Host access requirements
  1. For Linux Hosts Only
  2. For Windows Hosts Only
5. Command path verification
6. Host discovery and collection configuration steps
7. Host discovery and collection setup overview
8. Host discovery and collection maintenance overview
9. Before discovering hosts
10. Configure/Search
11. Manage credentials
  1. Example of credentials for Windows hosts
12. Manage WMI Proxy
13. Manage paths
14. Manage access control
15. Host management
16. Configure host discovery policies to populate the host discovery and collection view
  1. Discovery policy considerations
  2. Configure a Discovery policy
17. Execute and monitor host discovery
18. Discovery processes
  1. Method 1
  2. Method 2
19. Validate host connectivity
  1. Validate hosts
  2. Validation history
20. Show errors
21. Filter the host discovery and collection window - Hide/Unhide, remove
22. Search and export in host discovery and collection
  1. Basic Search
  2. Pre-Defined Search
  3. Advanced Parameters
23. Export in host discovery and collection
24. Configure and edit host probes
25. Propagate probe settings: Copy probes, paste probes
  1. Example of Probe Copy/Paste
  2. Probe Settings
Discovery policies for Veritas NetBackup
1. Task overview: Configure and monitor discovery policies
2. Discovery policies overview
3. About Discovery types
4. Activate a discovery license
5. Create and edit discovery policies
6. Exclude devices from discovery policies
7. Activate discovery probes in the NetBackup Data Collector policy
8. Monitor discovery processes
9. View client protection status
10. Reset Discovery Data
View and manage system notifications
1. Overview
2. Viewing system alerts
3. Defer or suppressing notifications
Customize with advanced parameters
1. Overview of advanced parameters
2. Use cases for advanced parameters
3. Adding an advanced parameter
4. Access control advanced parameters
5. General Data Collection advanced parameters
6. Cloud data collection advanced parameters
  1. Amazon Web Services (AWS)
  2. Microsoft Azure
7. Host discovery and collection advanced parameters
8. Backup Manager advanced parameters
9. Capacity Manager advanced parameters
10. Virtualization Manager advanced parameters
  1. VMWARE_COLLECT_UNUSED_PROPERTIES
  2. VMWARE_DATASTORE_TIMEOUT_SECONDS
Manage your Portal environment
1. Root folder and domains
2. Add/Configure a domain
3. Configure alerting for a domain
4. Community performance statistics for a domain
5. Manage your profile and set a language preference
6. Change your login password
Analyze files
1. Overview
2. File categories
3. Adding/Editing file categories
4. File list export
5. File list export output in CSV format
  1. Exported CSV file example
Troubleshoot the Portal
1. Support tools
2. Requesting a support package
3. File selector wildcards
4. Retrieving log files
  1. On a Windows platform
  2. On a Linux platform
5. Archiving script
6. Debug
  1. Debugging Level Scope
7. Login errors
8. Add notes to failed jobs
9. Host name processing - Filters and aliases
10. Change the Portal server's IP address
11. Changing the port for Portal server communication
12. Determine report rendering statistics
13. Clearing the inventory and report cache
Attribute inheritance overrides
1. Overview
2. Override inherited attribute values
  1. Use case 1
  2. Use case 2
Understanding report data caching
1. Understand report data caching
2. How reports and caching work together?
3. Store and purge data
4. Disable optimistic caching with portal.properties

Configure a Table in the SQL Template Designer

A table is the most basic chart used to represent data. Use the Move Up and Move Down feature to position the fields to easily select three fields.