Audit All Workstations with Expired Antivirus
List all workstations with expired antivirus software installed. Lansweeper scans the status of antivirus software during a Windows scan. This audit provides an overview of all the machines within your network for which the antivirus software has expired. When antivirus software has expired this either means that no more updates are provided or that the software does not protect the computer anymore. In either case, it is important to fix these issues as soon as possible to ensure your network is fully protected.
Workstations with Expired Antivirus Query
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName, tblAntivirus.DisplayName As Antivirus, tblAssets.Domain, tsysAssetTypes.AssetTypename As Type, tblAssets.IPAddress As [IP Address], tblAssets.Description, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Location, tsysIPLocations.IPLocation, tblAssets.Lasttried, tblAssets.Firstseen, tblAssets.Lastseen From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAntivirus On tblAssets.AssetID = tblAntivirus.AssetID Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID Where tblAssetCustom.State = 1 And tblAntivirus.productUpToDate = 0 Order By tblAssets.AssetName