Video Screencast Help
Search Video Help Close Back
to help

List all Machines with Office 2007 installed

Created: 14 Feb 2013 | 2 comments
The_yeti's picture
The_yeti
0 0 Votes
Login to vote

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

Discussion Filed Under:
, , ,

Comments 2 Comments • Jump to latest comment

Sumit G's picture
Sumit G Partner
List all Machines with Office 2007 installed - Comment:14 Feb 2013 : Link

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.

+1
Login to vote
Ashish-Sharma's picture
Ashish-Sharma Partner
List all Machines with Office 2007 installed - Comment:15 Feb 2013 : Link

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

SEPM Knowledgebase Documents  

 

0
Login to vote