Can I have the query below show the version of the software as well?  It just shows the software name.  I need versions of all the software too.

SELECT MAX(workstation.WORKSTATIONNAME) "Workstation",

MAX(aaaUser.FIRST_NAME) "User",

MAX(deptDef.DEPTNAME) "Department",

MAX(state.DISPLAYSTATE) "Asset State",

softl.SOFTWARENAME "Software Name" FROM SystemInfo workstation 

LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID 

LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID 

LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID 

LEFT JOIN DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID 

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

LEFT JOIN SoftwareInfo sinfo ON workstation.WORKSTATIONID=sinfo.WORKSTATIONID  LEFT JOIN SoftwareList softl ON sinfo.SOFTWAREID=softl.SOFTWAREID where softl.SOFTWARENAME like '%webex%'  GROUP BY workstation.WORKSTATIONID,softl.SOFTWARENAME order by 4