Hello Mario,
Thank you for posting question on Microsoft Windows Forum.
Based on your query of running a query in Configuration Manager (SCCM) to generate a report of all software installed on all the client machines. Well! In fact, listing all software on all machines is one of the most common tasks in SCCM. Nevertheless, because that dataset is massive, running a "select all" query can freeze your console or time out.
The suggestion here is to use built-in Reporting in SCCM.
- Go to the Monitoring workspace. Expand Reporting > Reports. Search for "Software - Companies and Products". Run the report named "Software registered in Add Remove Programs on a specific computer" (you can often leave the computer wildcard % to find all, though this may take a long time).
- Better alternative is to use the report named "Count of all instances of software registered with Add or Remove Programs" gives you a high-level summary of what is installed across the environment.
Hope the above information is helpful! If it is. Free feel to hit "Accepted".