Adding an SQL Query to the Filter in ITMS Management Views

You can create the queries and run them directly on the SQL server. You can also create filters based on these queries.
To create or edit an SQL query, you need to have the
Edit SQL Directly
system privilege.
  1. To add an SQL query to the filter in ITMS Management Views
  2. In the Symantec Management Platform, on the
    Manage
    menu, click
    Computers
    .
  3. In the navigation pane, under
    Filters
    , click the filter that you want to configure.
  4. In the content pane, in the upper right corner, click the double arrows to expand the filter details, and then click the
    Edit SQL
    symbol.
  5. In the
    Edit Raw SQL
    dialog box, write an SQL query, or paste an existing query, and then click
    Test query
    .
    If the query that you have configured is incorrect, the
    Results
    box displays an error message. You cannot save an incorrect query.
    If the query is correct, the
    Results
    box displays a list of computers.
    Filter evaluation may take a longer time depending on the complexity of SQL, specified criteria, and included filters.
  6. Click
    Close
    .
  7. Click the
    Save Filter
    symbol.
  8. In the
    Save Filter
    dialog box, specify the name and the location of the filter, and then click
    OK
    .