I need to add Resource State to this report, but don't know SQL very well.  Any help would greatly be appreciated. 

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 '%Visio%' ORDER BY 1,2