Hi Lansweeper Community,
I'm trying to return all hosts that have a specific software application installed but the software name includes '. I have Like 'blah%' which returns numerous results per host as its a three part application. Is there a was of querying something like any of these:
= 'software\'s' (Seems like an escape character as colouring updates in report but still errors)
= "software's" (returns as [software's]
The software I want to report on is: Malwarebytes' Managed Client
This is what I have right now:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Username,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
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
Where tblSoftwareUni.softwareName Like 'Malwarebytes%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version
The end goal is a report that says hosts without this and this and this installed so I need the specific software name rather than wildcard results for comprehensive coverage.
Apologies if this is a dupe and thanks in advance for any help!
