6Aug/070
WinZip count with version
SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count
FROM dbo.v_GS_INSTALLED_SOFTWARE
GROUP BY ProductName0, VersionMajor0
HAVING (ProductName0 = 'winzip')
Enjoy this article?
About Tom Lasswell
about myself.Tags
blog
cacti
camera
cluster
ConfigMgr
Datacenter
datadomain
dfs
finances
fun
gx
home
iphone
isy
netapp
network
opsmgr
phone
photos
reporting
san
SCOM
script
sms2003
sql
srm
toy
uptimedevices
vmware
work
xbmc
Twitter Feed
- @kix1979 link? What's the free connector?
- @vStorage finally! been looking forward to this feature. glad it's finally there. nice writeup btw.
- @3parfarley been using that for about a year now. :) when i first used it finally got a correct pizza order. hah
Personal
Vendor
Recent Posts
- ISY Python Script for controlling media lights via xbmc
- Schedule a URL into Maintenance Mode
- First iphone 4 post
- Designing Disaster Recovery … on a budget
- OpsMgr 2007 – No graphs in emailed reports