Dynamic groups and use of Wildcard

[BosOtter]

Hi, is it possible to create a Dynamic Group in Lansweeper and use a wildcard to group together all PC's ending with the number "1"

PC's are called:
S10001
S10002
S10003
S20001
S20002
S20003
S40001
S40002

Filter will obviously be "Asset Name" but have tried every option so not sure how to use a wildcard in this scenario

Also goes from S10011 S10101 etc, I only want to see the PC's with a "1" on the end
Thanks

[Bruce_B]

As the poster above me indicated, SQL syntax is used here, so if you know the exact length of the name underscores can be used, otherwise you can make use of the % wildcard, like so: S%1

[PeterJG · Accepted solution]

all queries are based on SQL syntax's so in sql the "_" is like any character.. so in your case the name would be S____1

that is 4 times the _

see if it works..