
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2013 05:59 PM
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.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2013 07:09 PM
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%'
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-13-2013 07:09 PM
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%'
