Software on workstation query

Hello, I have this query that reports on a particular software installed on all systems. How could I get the report to also show the model of workstation or if it is a server or workstation? Thanks.

SELECT WorkstationName 'PC Name',softl.SOFTWARENAME 'Software Name',softl.fileversion 'Version',aaaUser.FIRST_NAME 'User' FROM SystemInfo sys LEFT JOIN SoftwareInfo soft ON sys.WORKSTATIONID=soft.WORKSTATIONID LEFT JOIN SoftwareList softl ON soft.SOFTWAREID = softl.SOFTWAREID LEFT JOIN SoftwareType st ON st.SOFTWARETYPEID=softl.SOFTWARETYPEID LEFT JOIN Resources resource ON resource.resourceid=sys.workstationid LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID WHERE softl.SOFTWARENAME LIKE '%internet explorer 6%'