locked
Outlook 2007 - 2010 - 2013 and up RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    When I am running the queries:

    SELECT  b.Netbios_Name0,
b.User_Name0,
CASE  WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003'
WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007'
WHEN a.FileVersion LIKE '14.%' THEN 'Office 2010'
WHEN a.FileVersion LIKE '15.%' THEN 'Office 2013'
ELSE 'NULL'   END AS 'Office Version',
a.FileName,
a.FileVersion,
a.FilePath
FROM  v_GS_SoftwareFile a
JOIN v_R_System b ON a.ResourceID = b.ResourceID
WHERE FileName = 'outlook.exe'

ORDER BY
b.Netbios_Name0

    it is giving me one item per machine concerning outlook15 or outlook14 folder for outlook.exe but when looking at Resource Explorer I am getting confuse:

    I see Microsoft Office Outlook MUI (English) 2010 but also Microsoft Outlook MUI (English) 2013... why do I have two items ?

    I am trying to get a list of machines with potentially having two versions of outlook !!! 

    Thanks,
    Dom

    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

    Tuesday, March 22, 2016 7:04 PM

Answers

All replies