select si.workstationname as "工作站名称",si.loggeduser as "最后登录的用户", swl.softwarename as "软件列表",swi.fileversion as "软件版本", swmfg.NAME AS "制造商" from softwarelist swl  left join softwareinfo swi on swl.softwareid=swi.softwareid 

left join systeminfo si on swi.workstationid=si.workstationid 

LEFT JOIN SoftwareManufacturer swmfg ON swl.SWMANUFACTURERID=swmfg.SWMANUFACTURERID where swl.softwarename like '%ManageEngine%' order by 1