I need a query that will find devices that have avira anti-virus

[honestvip]

I need a query that will find devices that have avira anti-virus

[amirjafarian]

I used this to find symantec AV:

 

$computers = Get-ADComputer -Filter *

foreach ($computer in $computers)

{

$SymServices = Get-WmiObject -ComputerName $computer.Name Win32_Service -Property Caption -ErrorAction SilentlyContinue |where {$_.Caption -like "*Symantec*"}

if ($SymServices.Count -gt 0)

{

Write-Host "$($computer.Name) protected by Symantec"

}

}

[honestvip]

i need sql quey for Collection

[GarthMJ]

SQL is used for Report, WQL is use for Collections,

 

In either case you will find lots of example here.

http://smsug.ca/tags/WQL/default.aspx