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