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]
Recent Comments