cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jmzhs
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
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

View solution in original post

2 REPLIES 2
jmzhs
Engaged Sweeper II
You are awesome man! I ran the report and it works great. Thank you so much!
MikeMc
Champion Sweeper II
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