Software list - SQL - help needed

Hello

Is there a way to create queries graphically, using a third party app eventually?

Would somebody help me please on an SQL (mysql) for a List with installed Software

I am stuck at this point (see below) but I also need workstation state (in use, disposed, ...) , software type (managed, freeware, ...) as well as site, department and user and ordered by software

SELECT SystemInfo.WORKSTATIONNAME "Workstation",WmiSWUsageInfo.SOFTWAREUSAGE "Software_Usage",SWInstallationKeyInfo.SOFTWAREINFOID "Product_ID",SWInstallationKeyInfo.PRODUCTID "Software_ID",SoftwareLicenses.LICENSEKEY "Software_Key",SoftwareList.SOFTWARENAME "Software",Resources.RESOURCENAME "Licence" FROM SoftwareGroupMember INNER JOIN SoftwareInfo ON SoftwareGroupMember.SOFTWAREID=SoftwareInfo.SOFTWAREID INNER JOIN SystemInfo ON SoftwareInfo.WORKSTATIONID=SystemInfo.WORKSTATIONID LEFT JOIN ResourceOwner ON SystemInfo.WORKSTATIONID=ResourceOwner.RESOURCEID LEFT JOIN SDUser ON ResourceOwner.USERID=SDUser.USERID LEFT JOIN AaaUser ON SDUser.USERID=AaaUser.USER_ID LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID LEFT JOIN SoftwareList ON SoftwareInfo.SOFTWAREID=SoftwareList.SOFTWAREID LEFT JOIN WmiSWUsageInfo ON SoftwareInfo.SOFTWAREINFOID=WmiSWUsageInfo.SOFTWAREINFOID LEFT JOIN SWInstallationKeyInfo ON SoftwareInfo.SOFTWAREINFOID=SWInstallationKeyInfo.SOFTWAREINFOID LEFT JOIN SoftwareLicenses ON SoftwareInfo.LICENSEID=SoftwareLicenses.RESOURCEID LEFT JOIN Resources ON SoftwareLicenses.RESOURCEID=Resources.RESOURCEID WHERE SoftwareList.SOFTWARENAME like '%Microsoft Office%'

Thanks in advance for any help!

Regards, Marc