I'm trying to create a custom Software report. I have this so far but i cannot figure out how to get the total install count.
SELECT softwarelist.softwarename "Software_Name", Max(swmfg.NAME) "Manufacturer", Max(softwareinfo.fileversion) "Version" FROM softwareinfo LEFT JOIN softwarelist ON softwareinfo.softwareid = softwarelist.softwareid LEFT JOIN softwaretype ON softwarelist.softwaretypeid = softwaretype.softwaretypeid LEFT JOIN systeminfo ON softwareinfo.workstationid = systeminfo.workstationid LEFT JOIN softwaremanufacturer swmfg ON softwarelist.swmanufacturerid = swmfg.swmanufacturerid GROUP BY softwarelist.softwarename ORDER BY 1