Notification

Icon
Error

Computers with Anti-virus out of date - Computers with Anti-virus out of date

Posted: Thursday, August 13, 2020 9:44:09 PM(UTC)
ddanks

ddanks

Member Original PosterPosts: 2
1
Like
Hello, I am wondering if I can modify the built in report for anti-virus expired. I have several computers with 2, and even one or two with 3. Antivirus programs installed. But more often than not one of them is disabled and out of date. I am really hoping to get a report that shows me computers that have anti virus out of date for all of their anti virus. Not ones that have anti virus out of date for product A, but product B is fine.

Any help would be appreciated.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAntivirus.DisplayName As AntiVirus
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblDomainroles On tblDomainroles.Domainrole =
tblComputersystem.Domainrole
Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID
Where tblAntivirus.productUpToDate = 0 And tblState.Statename = 'Active' And
tblDomainroles.Domainrolename In ('Stand-alone Workstation',
'Member Workstation')
Order By tblAssets.Domain,
tblAssets.AssetName

Active Discussions

Installer Deploy SolarWinds Take Control Agent
by  Corey Lambert   Go to last post Go to first unread
Last post: 8/6/2020 2:23:22 PM(UTC)
Installer Microsoft Edge (Chromium) 84.0.522.44
by  PLSJohnJohn   Go to last post Go to first unread
Last post: 7/24/2020 10:22:19 PM(UTC)
Installer Windows 10 Upgrade
by  CyberCitizen  
Go to last post Go to first unread
Last post: 7/8/2020 1:07:47 AM(UTC)
Installer Installer - Microsoft Office
by  Florian_Eigsi   Go to last post Go to first unread
Last post: 6/29/2020 3:33:20 PM(UTC)
Installer Firefox ESR 68.8.0 MSI Installer
by  PLSJohnJohn  
Go to last post Go to first unread
Last post: 5/11/2020 4:33:50 PM(UTC)
Installer Update Chrome browser with GoogleUpdate.exe ?
by  Inna Ptushkina   Go to last post Go to first unread
Last post: 5/4/2020 8:39:29 PM(UTC)
Installer Bios Update for Dell all in one
by  Florian_Eigsi  
Go to last post Go to first unread
Last post: 4/2/2020 11:36:43 AM(UTC)