SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count
FROM dbo.v_GS_INSTALLED_SOFTWARE
GROUP BY ProductName0, VersionMajor0
HAVING (ProductName0 = 'winzip')
This is a quick one, it's been forever since I've posted here. After moving back…
Simple command turned crazy. I ended up coming up with this due to the fact…
Phew, this one took a minute to figure out. ConnectWise has a form based documents…
I've found myself at a new job, recreating many of the processes that I spent…
Wow, it's been a while since I've done a real post on this site. I've…
When using AutoTask's API it's required to lookup a various amount of picklist values that…