Defining customized views to build SQL queries

A view is a metadata layer that connects to a data source. By using the view, you create SQL queries to fetch data from the BMC Helix ITSM database. You can create a custom view or copy an existing out-of-the-box view and customize it. The view defines relationships between tables and identifies the database fields required for creating SQL queries for the Service Management query type. As a BMC Helix Dashboards user, create a SQL query based on this view in the visual query builder.

Related topics

Creating-SQL-queries-by-using-Visual-Query-Builder

Service-Management-query

Perform the following tasks to create a customized view in Reporting Metadata Studio and build a SQL query based on it:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*