רשימת מחשבים ותוכנות - סקריפט SQL

רשימת מחשבים ותוכנות - סקריפט SQL

SELECT systeminfo.workstationname "Workstation",
( 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 systeminfo.workstationname,
softwarelist.softwarename ORDER BY 1