Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gdavis
Engaged Sweeper II
I would like to create a report to show all versions of a certain software title. Can I wildcard be used in the report builder application? I have tried %software title% and software title* with no luck. I am using v5.0.0.76. Thanks in advance.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
The Lansweeper report builder uses standard SQL queries. SQL uses % as a wildcard. The example criterion below will make your report list all software packages whose name includes the word "Lansweeper".
WHERE tblSoftwareUni.SoftwareName Like '%lansweeper%'

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
The Lansweeper report builder uses standard SQL queries. SQL uses % as a wildcard. The example criterion below will make your report list all software packages whose name includes the word "Lansweeper".
WHERE tblSoftwareUni.SoftwareName Like '%lansweeper%'

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now