SQL questions on an software report

Hello

I would like to create a list displaying all PC's which are not-disposed and which have thunderbird and Lotus installed.

The basis query is here; I need some help to filter for the not-disposed workstations (in the where clause)

SELECT sys.WORKSTATIONNAME 'Workstation Name',softl.SOFTWARENAME 'Software Name',aau.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 ResourceOwner resown ON soft.WORKSTATIONID=resown.RESOURCEID LEFT JOIN SdUser sdu ON resown.USERID=sdu.USERID LEFT JOIN aaauser aau ON sdu.USERID=aau.USER_ID WHERE (softl.SOFTWARENAME like '%Thunderbird%' ) or (softl.SOFTWARENAME like 'Lotus Notes%' )

Please order this list by sys.WORKSTATIONNAME as well

Any help would be appreciated

Is there a graphical tool available to connect to mysql sd+ database and to create reports in a graphical way?

Thanks a lot for any feedback

best regards, Marc