
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2017 01:56 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-15-2017 09:16 PM
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..
that is 4 times the _
see if it works..
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-19-2017 10:12 AM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-15-2017 09:16 PM
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..
that is 4 times the _
see if it works..
