

Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID = Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID, Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tsysIPLocations On tsysIPLocations.LocationID = Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg When Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) <= 5 Then When tblSoftware.softwareVersion Like '6%' AndĬast(ParseName(tblSoftware.softwareVersion, 2) As bigint) < 02 Then TblSoftwareUni.SoftwarePublisher As Publisher, TsysAssetTypes.AssetTypename As AssetType, Winrar Vulnerability Query Select Top 1000000 tblAssets.AssetID, Identify which computers need an update to be secure again any abuse of this vulnerability. Find all computers in your network which have a Winrar installation. The audit below is color-coded to provide an overview of all Winrar installations while at the same time indicating whether they should be updated or not to prevent any security issues. Additionally, outdated components in older versions can be abused to redirect users to malicious websites. Starting with a very old vulnerability that allows attackers to extract malicious software to anywhere. However, there have been multiple vulnerabilities in older versions. Winrar, the never-ending trial software is still one of the most popular archiving and compression tools. Find All Vulnerable WinRAR Installations on Your Network
