Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  2. IT Analytics Help
  3. Section IV. End user
  4. Work with the SQL template designer

Work with the SQL template designer

This section includes the following topics:
  • SQL template designer overview

  • Database Published Views

  • Access the Database Published Views from the CLI

  • Access the Database Published Views from the SQL Template Designer

  • Steps to Create SQL Templates

  • Create a SQL Template

  • Configure SQL Template Scope Selector Components

  • Construct the SQL Query

  • Help for Database Views

  • Accessing the Published Database Views from the CLI

  • Special Characters in SQL Queries

  • Sample SQL Queries

  • Use Functions in Queries

  • Format the SQL Template Output

  • Number, Size, Date, and Time Formatting

  • Alignment, Aggregation, Bar Type, and Bar Type Color

  • Area, Line or Column Sparkline Format for a SQL Tabular Report Template

  • Configure a Bar Chart SQL Template

  • Example of a Bar Chart SQL Template: Host CPU Performance

  • Configure a Line Chart SQL Template

  • Configure a Donut Chart SQL Template

  • Example of a Donut Chart SQL Template: NetBackup Job Size by Job Type

  • Configure a Gauge Chart SQL Template

  • Configure a Horizontal Bar Chart SQL Template

  • Example of a Horizontal Bar Chart SQL Template: Host CPU Performance

  • Configure a Horizontal Stacked Bar Chart SQL Template

  • Example of a Horizontal Stacked Bar Chart SQL Template: Available/Allocated Capacity

  • Configure an Area Chart SQL Template

  • Example of Area Chart SQL Template: Allocated Available

  • Configure a Pie Chart SQL Template

  • Example of a Pie Chart SQL Template: Overall Job Status Summary

  • Configure a Pivot Table SQL Template

  • Example of a Pivot Table SQL Template: NetBackup Job Size

  • Configure a Stacked Bar Chart SQL Template

  • Example of a Stacked Bar Chart SQL Template: Host CPU Performance

  • Configure a Table in the SQL Template Designer

  • Example of a Table SQL Template: Host Group Membership List

  • Example of a Table SQL Template: Exposed Clients

  • Save and Share Report Templates

  • Advanced SQL Report Template Options

  • Creating Drilldowns

  • Using SQL Templates for Drilldowns

  • Create mouse-over hovers

  • Add an External Reference

  • Inventory Report Configuration

  • About the Reports in the Inventory

  • Edit a Custom Report Template

  • Export/Import SQL Templates

  • Export a SQL Template

  • Import a SQL Template

Feedback

Was this page helpful?
Previous

Troubleshooting Dynamic Templates

Next

SQL template designer overview

Feedback

Was this page helpful?