Report help: Computers that do not have latest antivirus

[WFheath]

Hello,

Our company is using Lansweeper Premium 4.2.0.21

I was wondering if there was a canned report or a best practice for this query

"Domain Computers that do not have Symantec Endpoint Protection 12.1.2015.2015 32 or 64 bit"

Thanks

[Hemoco · Accepted solution]

TblComputers does not exist in Lansweeper 5.0. Many tables were renamed or added in 5.0. Please use the report below instead.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress As IP,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%YourSoftware%' and tblSoftware.softwareVersion Like '%YourVersion%') And
tblAssets.Lastseen <> '' And tblAssets.Assettype = -1
Order By tblAssets.AssetUnique

[Hemoco]

Please use the report below for the information you are after.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblComputers.Lastseen From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where tblComputers.Computername Not In (Select tblSoftware.ComputerName From tblSoftware Where tblSoftware.softwareName Like '%Symantec Endpoint Protection%' And tblSoftware.softwareVersion = '12.1.2015.2015') And tblComputers.Lastseen <> '' Order By tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.

[kris]

Hi,
I was searching for a similar code to search for some missing programs, when I tried to use the code you provided, I get an error tblComputers is an invalid object, I am using version 5041, is it under a different name?

Lansweeper wrote:
Please use the report below for the information you are after.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblComputers.Lastseen From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where tblComputers.Computername Not In (Select tblSoftware.ComputerName From tblSoftware Where tblSoftware.softwareName Like '%Symantec Endpoint Protection%' And tblSoftware.softwareVersion = '12.1.2015.2015') And tblComputers.Lastseen <> '' Order By tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.