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.- To add an SQL query to the filter in ITMS Management Views
- In the Symantec Management Platform, on theManagemenu, clickComputers.
- In the navigation pane, underFilters, click the filter that you want to configure.
- In the content pane, in the upper right corner, click the double arrows to expand the filter details, and then click theEdit SQLsymbol.
- In theEdit Raw SQLdialog box, write an SQL query, or paste an existing query, and then clickTest query.If the query that you have configured is incorrect, theResultsbox displays an error message. You cannot save an incorrect query.If the query is correct, theResultsbox displays a list of computers.Filter evaluation may take a longer time depending on the complexity of SQL, specified criteria, and included filters.
- ClickClose.
- Click theSave Filtersymbol.
- In theSave Filterdialog box, specify the name and the location of the filter, and then clickOK.