→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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%'