Making SMS Queries More Flexible
June 26, 2000
by Dana Daugherty
In this article I'll show you how to use string values in query criterion to give you the information you need about your site.
Try this- while in the SMS Console open up the query tree, right click on Queries, select New Query. Enter a name in the text box. Select Edit Query Statement. On the General Tab select the star symbol, then hit the select button. Set the Attribute Class to System Resources and Attribute to Name. Select OK. You should now be looking at the Query Statement Properties sheet. From here select the Criteria Tab. Next select the star symbol to create a criteria. Hit the select button on the General tab, set the Attribute Class to System Resources and the Attribute to Name, then hit OK. Set the Operator to ?is like? and the value to [A-G]%. Select OK to each page until you reach the console. Result should be all systems with names beginning with A-G