Report To Show If MalwareBytes Is Installed and Version

[jmzhs]

Hi,

I'm wondering if somebody has built a report or can help with a report to identify who has MalwareBytes installed which isn't a server. Also, I'm trying to identify if corporate or free version is installed and wondering if there's a way I can flag that on a column as well as see if the virus definitions are up to date. I'm not sure if Lansweeper can pull that information but any help would be greatly appreciated! Here are the columns I'm looking for below

Asset Name | ip address |Operating System| Installed Y/N | Version (corp or free) | Definitions up to date

[jmzhs]

You are awesome man! I ran the report and it works great. Thank you so much!

[MikeMc · Accepted solution]

I can't fully test this query because we don't use Malwarebytes in our environment, but I did use this post as a reference: https://forums.malwarebytes.org/topic/151887-how-to-detect-if-installed-mbae-is-consumer-or-corporat...

Select Distinct tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress As IP,
  tsysOS.OSname,
  tsysOS.Image As icon,
  (Case When s.AssetID Is Not Null Then 'True' Else 'False' End) As Installed,
  (Case When s.softwareVersion Like '%.%.2.%' Then 'Corporate'
    When s.softwareVersion Like '%.%.1.%' Then 'Consumer' Else 'Unknown'
  End) As Version,
  s.softwareVersion,
  (Case
    When (tblAntivirus.productUpToDate = 1 And s.AssetID Is Not Null) Then
    'Up To Date'
    When (tblAntivirus.productUpToDate = 0 And s.AssetID Is Not Null) Then
    'Out of Date' Else 'Unknown' End) As AVStatus
From tblAssets
  Inner Join tblComputersystem On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Outer Join tblAntivirus On tblAntivirus.AssetID = tblAssets.AssetID
  Left Outer Join (Select Distinct tblSoftware.AssetID,
    tblSoftware.softwareVersion
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblSoftwareUni.softwareName Like 'Malwarebytes%') s
    On s.AssetID = tblAssets.AssetID
Where tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName