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.

David
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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.

David
Answered 02/09/2010 by: simonds
Senior Yellow Belt

Please log in to comment
0
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.
Answered 02/09/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
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.

David
Answered 02/09/2010 by: simonds
Senior Yellow Belt

Please log in to comment
0
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.
Answered 02/09/2010 by: afzal
Fourth Degree Green Belt

Please log in to comment
0
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
or
[!charlist]

Answered 02/12/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
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:

^(MN(10[8,9]|111|20[0,1,4])|MA2|FH1)

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.
Answered 02/16/2010 by: sdickenson
Senior Yellow Belt

Please log in to comment
0
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.
Answered 02/16/2010 by: lindsamw
Orange Senior Belt

Please log in to comment
Answer this question or Comment on this question for clarity