KACE Product Support

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

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.

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

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.

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]



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.

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.