PostgreSQL Custom Query for a list of workstations and the software installed for AssetExplorer

PostgreSQL Custom Query for a list of workstations and the software installed for AssetExplorer

I'm attempting to create a couple of custom reports, but have very limited experience with creating query reports. I'd like to create a query that shows all the Windows 10 workstation with the name starting with "desktop" and a list of software that is installed on each of those workstations. Thanks.

                New to ADSelfService Plus?