list computer with antivirus up-to-date

[LaurentV]

Hi all,

I try to create a report that list all computers in my domains and give me the status of the antivirus (up-to-date or not).
all reports available don't give me the status...and i don't find how to integrate it in my reports.

can you help me?

Laurent

[LaurentV]

thanks for your help 🙂

[Susan_A · Accepted solution]

A sample report can be seen below. Keep in mind that we can only detect the status of anti-virus software pulled from WMI. See this knowledge base article for more information.

If you are interested in building or modifying reports, we would recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  
• Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAntivirus.DisplayName As Software,
  Case tblAntivirus.onAccessScanningEnabled When 1 Then 'enabled'
    When 0 Then 'disabled' End As Status,
  Case tblAntivirus.productUpToDate When 1 Then 'up-to-date'
    When 0 Then 'out-of-date' End As VirusSignature
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Software