→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BosOtter
Engaged Sweeper
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
1 ACCEPTED SOLUTION
PeterJG
Champion Sweeper II
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..

View solution in original post

2 REPLIES 2
Bruce_B
Lansweeper Alumni
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

Dynamic asset group
PeterJG
Champion Sweeper II
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..

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now