This is not really supported by SQL. If your database is running on SQL server Express or higher edition you could use the Stuff function to aggregate all software names scanned on a computer into one single column. But that likely will get quite a long column and won't be useful for further processing. We rather recommend creating a basic report, exporting it to XLS and using a pivot table in Excel.
