Symantec Management Platform (Notification Server)

Within NS 6.x I went to all reports and drilled down to:  Computers With Selected Application Installed.   I then tried many different strings to find any/all versions of Microsoft Project.   No results came back.   I then tried entering %excel% and it returned nothing.  I then tried %Microsoft Office% and it only retunred about 250 machines Now, I know that is false since or company image has Office baked into it so it show about 1,000 machines.  

If I want to query for all versions of Microsoft Project what would be string be?  

And why would it only find 250 machines when I search for %Microsoft Office%?  It should return close t0 1,000 workstations.

I could not find a report in NS6 that is called: Computers With Selected Application Installed. What is the path in the NS console?


Try this report for finding Office:

SELECT DISTINCT
 p.[name] [Office Name],
 COUNT (*) [Count]
FROM inv_aex_os_add_remove_programs p 
  JOIN vcomputer c ON c.guid = p._resourceguid
 WHERE (p.[Name] = 'Microsoft Office XP Professional with FrontPage'
   OR p.[Name] = 'Microsoft Office XP Professional'
   OR p.[Name] = 'Microsoft Office XP Standard'
   OR p.[Name] = 'Microsoft Office Professional Edition 2003'
   OR p.[Name] = 'Microsoft Office Standard Edition 2003'
   OR p.[Name] = 'Microsoft Office Professional Plus 2007'
   OR p.[Name] = 'Microsoft Office Enterprise 2007'
   )
GROUP BY p.[name]
Order BY COUNT (*)