~/2007/08/06/winzip-count-with-version.md

WinZip count with version

---
author: Tom Lasswell
date: 2007-08-06
updated: 2024-02-12
read: 1 min
in:   [engineering]
tags: [reporting, sms2003]
---

SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count FROM dbo.v_GS_INSTALLED_SOFTWARE GROUP BY ProductName0, VersionMajor0 HAVING (ProductName0 = 'winzip')