Full Software Inventory

This is a full soft. inventory report. It could be a little bit confusing depending how many machines you have in your SCCM and how many softwares installed, but it will help you for a first overview:




select 

            DisplayName0 as 'Product0', 
            Version0 as 'Version',
            Count('Version') as 'Totals'

from 
            v_GS_ADD_REMOVE_PROGRAMS
where              
DisplayName0 like '%'

Group by 

            DisplayName0,
            Version0