select swl.softwarename "软件名称",si.workstationname "工作站名称" , aaaUser.FIRST_NAME "所有者", LONGTODATE(swi.filecreatedtime)  "安装时间" from softwarelist swl left join softwareinfo swi on swl.softwareid=swi.softwareid left join systeminfo si on swi.workstationid=si.workstationid left join Resources resource ON si.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID  where swl.softwarename like '%<软件名称>%'