Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Report Creation Altiris 7.1

Created: 04 Nov 2013 • Updated: 06 Nov 2013 | 2 comments
This issue has been solved. See solution.

I'm attempting to either find, or create a report showing all of our client that are running Outlook 2007 SP1 or SP2. 

The network guys are looking to run a hotfix but in order to do so all our clients need to have Outlook 2007 SP3. Which is the reason for this request.

Thank you in advance.

 

Operating Systems:

Comments 2 CommentsJump to latest comment

ssv1984's picture

Hi  BJHughey ,

FYA,

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%' for the Company OR '%Outlook 2007 %' for the Name.

Or you can check with the below query,

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 'Microsoft Outlook 2007%' AND arp.InstallFlag=1

Thanks,

Siva

SOLUTION
BJHughey's picture

@ssv1984

Thank you for your help in this matter! I was able to find everything that I needed.