mack_jason

I have several reports that do counts of MS Office 2007 products by Add/Remove programs and within the last month the numbers have doubled. When I went to check it out I noticed a new entry in the AeX OS Add Remove Programs data class of machines.

I have created a work around by doing a not like and using a portion of the product ID.

Has anyone else run into this?

---- Fix

select distinct
app.[name], COUNT (app.[name]) [Count]
from Inv_AeX_OS_Add_Remove_Programs app
join vcomputer vc on vc.[guid] = app.[_resourceguid]
where app.[name] like 'Microsoft Office Visio Professional 2007'
and app.[product id] not like '89%' -- Excludes Visio, Project and Office 2007
and app.[name] not like '%Service Pack%'
group by (app.[name]) , app.[name]
order by [Count]
desc