Custom Report

I would like to custom the report as below format.

User Name Workstation Software Name Manufacturer

What is the SQL query script? Thanks