Defining a Resource Query for a Filter

A resource query is based on the tables that are available in the CMDB. The Query Builder is a user-friendly tool that provides a standard template and lets you select the tables and fields that you want to use. It helps you to define the query to suit your requirements. You do not need any SQL knowledge to define a resource query. The resource query is converted to SQL automatically, and the SQL is run on the CMDB to extract the appropriate resources.
This task is a step in the process for creating or modifying a filter.
  1. To define a resource query for a filter
  2. In the Symantec Management Console, on the
    Manage
    menu, click
    Filters
    .
  3. In the left pane, click the filter that you want to modify.
  4. In the right pane, in the
    Filter Definition
    panel, specify the resource query details on the appropriate tabs.
    Query
    Fields
    The fields and the data class attributes to use in the query.
    Query Parameters
    The parameters that are used in the query. These are internal parameters for SQL use, not user parameters.
    Parameters are not commonly used in filter queries, but may be useful for getting registry information. For example, an agent version number for an upgrade.
    Filter Expressions
    The conditional statements that are used to further refine the results of the query. Each statement or grouped statement can be considered a filter. You need to create the statements that you want to use and group them accordingly.
    Resolved Query
    The SQL code that is run on the CMDB to extract the filter results.