Use Wild Card in Report Builder

gdavis · ‎06-13-2013

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.

Hemoco · ‎06-13-2013

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

Hemoco · ‎06-13-2013

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

Use Wild Card in Report Builder

New to Lansweeper?

Try Lansweeper For Free