Creating custom query to find all software installed on all workstation

Creating custom query to find all software installed on all workstation

 Is there any way to create a report to show all software (with updates and servicepacks for Microsoft products) installed on all workstations in servicedesk in this format:

   
  1. hostname1,software1
  2. hostname1, software2
  3. hostname2, software1
  4. hostname2, software3
  5. .........

?

                  New to ADSelfService Plus?