Establishing Support Structure › Stored Queries Setup

Stored Queries Setup

CA SDM supports use of stored queries to produce two kinds of data:

• Scoreboard Queries let you customize the web interface scoreboard by adding counter fields for items of interest.
• KPI Queries let you retrieve historical information for a specified time period on the value of a counter for use in web-based reporting.

Stored queries apply to all service desk models. Stored queries are not intended to bring users to a new page.

Administrators define the stored queries that are available to users. You can use the predefined stored queries that are installed with CA SDM, or define your own. You can define stored queries by using the administrative function of the web interface.

Consider the following information about stored query definitions:

• A valid stored query clause is integrated into an appropriate SELECT statement and passed to the underlying DBMS engine for processing. To develop the SELECT statements, see the object definition files in the following directories:
  • Windows: installation-directory\bopcfg\majic directory
  • UNIX: $NX_ROOT/bopcfg/majic directory
• Stored queries use the object and attributes statements for building the SQL WHERE clause instead of the field names at the database level.
• CA SDM does not support Cartesian product joins for stored queries. To help ensure that your stored query does not produce a Cartesian product join, enter the following command appropriate for your system.
  • Windows: bop_cmd -f installation-directory\bopcfg\interp\bop_diag.frg "check_queries()"
  • UNIX: bop_cmd -f $NX_ROOT/bopcfg/interp/bop_diag.frg "check_queries()"

  Update any queries that are flagged as a result to avoid Cartesian product joins.

• The URL stored query is an option offered while creating stored queries. The URL stored query runs a query and returns numerical results that only work with Knowledge Management.

Note: For more information about the object definition syntax, see the Technical Reference Guide. For more information about defining stored queries, see the Online Help.