→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
LaurentV
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
LaurentV
Engaged Sweeper II
thanks for your help 🙂
Susan_A
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now