Notification

Icon
Error

Wildcard in Report

Posted: Thursday, May 9, 2019 12:26:58 PM(UTC)
Declan Marks

Declan Marks

Member Original PosterPosts: 2
0
Like
I have copied the built in report 'Software: By computer' and have removed unneeded columns. I am now trying to exclude approved software and just list software that hasn't been approved. But there are many different versions of software installed on our network so using wildcards would make the query look cleaner This is my example query below but the wildcard do not work.

Code:
Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblSoftwareUni.softwareName As software,
  tblSoftware.softwareVersion As version,
  tblSoftwareUni.SoftwarePublisher As publisher,
  tblAssets.Username
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
    And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblSoftwareUni.softwareName Not In ('.NET Core SDK%', 'GIMP%")',
) And tblAssetCustom.State = 1
Order By software,
  version
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 5/13/2019 3:26:18 PM(UTC)
I don't think IN supports wildcards. So you'll have to just use AND instead and make multiple clauses for each software

Where tblSoftwareUni.softwareName NOT LIKE '.NET Core SDK%' And tblSoftwareUni.softwareName NOT LIKE 'GIMP%'

Additionally I would suggest looking at the report Software: Unauthorized software, which sounds like the thing you're looking for.

Active Discussions

Lansweeper local admin users of a specific device
by  kdunnett   Go to last post Go to first unread
Last post: 5/25/2020 9:30:26 PM(UTC)
Lansweeper How to get total disk usage of all VM assets
by  Erik.T  
Go to last post Go to first unread
Last post: 5/25/2020 4:49:58 PM(UTC)
Lansweeper Windows Server 2016 & Patch Tuesday May 2020
by  Hendrik.VE   Go to last post Go to first unread
Last post: 5/22/2020 8:20:05 PM(UTC)
Lansweeper Users mapped "shared" printers
by  Andy.S  
Go to last post Go to first unread
Last post: 5/22/2020 4:16:23 PM(UTC)
Lansweeper Report on Assets in a Static Group
by  Andy.S   Go to last post Go to first unread
Last post: 5/22/2020 2:55:03 PM(UTC)
Lansweeper Windows 10 Activation
by  TruSynergy  
Go to last post Go to first unread
Last post: 5/21/2020 7:54:25 PM(UTC)
Lansweeper Filtering Report Based On Active Status
by  CyberCitizen   Go to last post Go to first unread
Last post: 5/21/2020 4:04:33 AM(UTC)
Lansweeper Windows: Unauthorized Administrators (Built-in)
by  Jackie.L  
Go to last post Go to first unread
Last post: 5/20/2020 8:01:17 PM(UTC)