Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

List all Machines with Office 2007 installed

Created: 14 Feb 2013 • Updated: 11 Nov 2014 | 2 comments
This issue has been solved. See solution.

How do I create a report listing all machines with Office 2007 installed?

Somthing like:

List All Computers with Named Like Microsoft Office Shared MUI 2007"

This SQL report shows me that I have 367 computers with office 2007 installed, but I need a list of thoes 367 machiens .

Select arp.[DisplayName], arp.[DisplayVersion], Count(*)

from Inv_AddRemoveProgram arp

Where arp.[DisplayName] like '%Microsoft%Office%2007%'

Group by arp.[DisplayName], arp.[DisplayVersion]

Jeremy

Comments 2 CommentsJump to latest comment

Sumit G's picture

Check the below forum

https://www-secure.symantec.com/connect/forums/how...

SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department

FROM vComputer vc
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
ON vc1.Name = vc.Name
INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
INNER JOIN vUser vu ON vc.[User] = vu.Name
WHERE arp.DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1
 
 
 
Note : You can Change Software name Like :'Adobe Flash Player

Regards

Sumit G.

SOLUTION
Ashish-Sharma's picture

Hi,

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] 

Check this thread also

https://www-secure.symantec.com/connect/forums/tracking-office-2007-inventory-solution-reports

There are default reports available for you if you go to Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer.  For example, using the Installed Software report, type %Microsoft Office Shared MUI 2007%' for the Company  Name.

Thanks In Advance

Ashish Sharma

SOLUTION