Asset Management Suite

Has anyone created an Inventory Solution report to give you stats on the # of office 2007 installations are present? I was trying to modify the Count of MS Products Installed report to add the GUID for Offie 2007 but i am not getting any results.

Searching for Office products isnt quite a simple process because of two things.

1) Microsofts inconsistant naming conventions
2) The way Altiris pulls information about applications

However I have made a query to track all versions of all the 2007 office apps. First, create a report and paste the following SQL into it. This should give you a full count of the installations of any application within the office 2007 series.

SELECT  COUNT(* ) AS 'Count',     
     [name],     
     version     
FROM   inv_aex_os_add_remove_programs     
WHERE  [name] LIKE 'Microsoft Office%2007'     
GROUP BY [name],version     
ORDER BY [name]     

If this produces too many entries give me the names of the application suites you are looking for and I can create filters for it.