WinZip End of Life Audit

Find End of Life WinZip Installations

Winzip is a trialware software for file archiving and file compression. It provides additional features and usability for file compressing and archiving that the standard Windows solution does not provide. If you’ve got WinZip in your environment, it is important to ensure that your installations are up-to-date you don’t risk having outdated software risk which can post a security risk in your environment. To help you get an overview of the WinZip end of life status, you can use the report below to get a list of all machines in your environment that have a WinZip installation. You can read more about the end of life in WinZip the end of life blog post.

WinZip End of Life Audit Query

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
subquery1.Software,
subquery1.Version,
subquery1.Publisher,
subquery1.EOLDate,
Case
When GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery1.EOLDate) As NVARCHAR) + ' days remaining'
End As [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() > subquery1.EOLDate Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
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
Left Join (Select tblSoftwareUni.softwareName As Software,
tblsoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When Cast(ParseName(tblsoftware.softwareVersion, 3) As bigint) < 22 Then
'2019-01-01'
When tblsoftware.softwareVersion Like '9.%' Then '2019-01-01'
When tblsoftware.softwareVersion Like '10.%' Then '2019-01-01'
When tblsoftware.softwareVersion Like '11.%' Then '2019-01-01'
When tblsoftware.softwareVersion Like '12.%' Then '2019-01-01'
When tblsoftware.softwareVersion Like '22.0%' Then '2019-01-01'
When tblsoftware.softwareVersion Like '22.5%' Then '2021-10-01'
When tblsoftware.softwareVersion Like '23.%' Then '2022-09-01'
When tblsoftware.softwareVersion Like '24.%' Then '2023-09-01'
When tblsoftware.softwareVersion Like '25.%' Then '2024-09-01'
When tblsoftware.softwareVersion Like '26.%' Then '2025-09-01'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where tblSoftwareUni.softwareName Like '%WinZip%' And
tblSoftwareUni.softwareName Not Like '%support%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where subquery1.Software Like '%WinZip%' And subquery1.Software Not Like
'%support%' And tblState.Statename = 'Active'

Show

Hide