Enterprise vs OEM

Did you every want to know how many copies of MS Office you had that were Enterprise vs OEM?

 

This SQL query along with your SMS data will help you out in finding this data.

 

select

            DisplayName0 as ‘Product’,

            case right(left(Prodid0,3),1)

            When ‘0’ then ‘Enterprise’

            When ‘1’ then ‘Retail/OEM’

            when ‘2’ then ‘Trial’

            else ‘Unknown’

            end as ‘Version’,

            Count(‘Version’) as ‘Totals’

from

            v_GS_ADD_REMOVE_PROGRAMS

where

            publisher0 = ‘Microsoft Corporation’

            and displayname0 like ‘%Office%’

Group by

            DisplayName0,

            right(left(Prodid0,3),1)

Order by

            Displayname0, [Version]

Leave a Reply

Your email address will not be published. Required fields are marked *