Filter Wildcards

I work for a school district and I am having problems creating filters that accurately reflect our deployment requirements. I hit a wall when I find the need for more than the four criteria. Before I rename 450 PCs I was hoping to find a better solution.

Our PCs are named SITE-ROOM-PC. The teacher's PC in each room ends in a -1. Some teacher's PCs are named -1A, -1B, -1C because of replaced equipment.

My first filter attempt
(Name begins with SITE-
AND Name contains -1)
gave me a list which included SITE-LAB-11, SITE-11-2, etc. which are not teacher PCs.

All other attempts run into a limitation on how many conditions I can use.

If I could use a wild card I would be all set
System Name begins with SITE-
AND System Name ends with -1*

Can you use wild cards of some sort? If I could test for a Label within a Filter that would work too.


0 Comments   [ + ] Show comments

Answers (7)

Posted by: simonds 13 years ago
Senior Yellow Belt
I just found the Label Name criteria in the filter options so I can make things work using that. I would still like to know if wild cards are possible.

Posted by: airwolf 13 years ago
Red Belt
If you go to the Filter tab under Reporting, you can create a SQL filter from scratch or modify an existing filter with as many different criteria as you like. It's not as easy as using the four filter fields, but you've got the power (if you are comfortable modifying SQL). Your only other option is to use REGEX to create filter expressions to pattern match instead of using wildcards. The wildcard character for SQL, by the way, is the percentage symbol (%). For example, "begins with SITE-%-1" would match everything that begins with SITE- and ends with -1. However, the filter also automatically throws a % at the end of the "begins with" match, so it would really be "SITE-%-1%". Use a REGEX if you want a very precise filter.
Posted by: simonds 13 years ago
Senior Yellow Belt
Thank you!

I'm not comfortable enough with SQL to be able to create my own filter but I have no problem modifying (slightly) an existing one.

Posted by: afzal 13 years ago
Fourth Degree Green Belt
You can create the filter with label name criteria and then modify it using Reports->Filters tab.
Search the "LIKE" clause in the SQL statement and modify the criteria "SITE-%-1%" as mentioned by David.
Posted by: GillySpy 13 years ago
7th Degree Black Belt
You can use SQL wildcards in the UI fields.

here's a list I found. I frequently use the first two. Haven't tried the others -- usually use regex at that point.

Wildcard Description
% A substitute for zero or more characters
_ A substitute for exactly one character
[charlist] Any single character in charlist

[^charlist] Any single character not in charlist

Posted by: sdickenson 13 years ago
Senior Yellow Belt
David, we name our PC's somewhat similarly (BuildingRoom-Asset) and make heavy use of regex filters on the PC's name for creating dynamic labels. We then deploy software to these labels. This allows us to ensure that certain software (i.e., Kidpix) is always on certain machines (i.e., lower school classrooms) regardless of the asset tag (for when computers are replaced or moved). It's all based on the location information in the name.

A sample regex that we use looks like this:


This looks a little daunting at first, but is really quite easy to grasp once you read up on regular expression syntax a bit. That one criteria covers all of our lower school classrooms in three different buildings.

A quick Google of "regex intro" and "regex cheatsheet" turns up more than few great resources. Spend 30 minutes learning them - it's worth your time for more than just the KBOX. I've used them for years in everything from Perl scripts to mail server configurations.
Posted by: lindsamw 13 years ago
Orange Senior Belt
My dynamic labels are all based off of OU in the Active Directory, works like a Champ so far, really allows me to account for those odd ball PC's that someone named as a joke instead of following naming convention.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ