Reporting Group

HI

Can we get SQL Query using which we get report of Microsoft office version whether it is 32 or 64 Bit

HostName, Software Installed, Operating system, Product version (32/64Bit), etc

Hope that help you.

A "Simple" SQL Report for Reporting on Microsoft Office Installed Versions

https://www-secure.symantec.com/connect/articles/simple-sql-report-reporting-microsoft-office-installed-versions

https://www-secure.symantec.com/connect/forums/report-ms-office

Also: https://www-secure.symantec.com/connect/forums/ds71-create-report-show-office-version

Hi Anton

we need office version whether it is 32 or 64 bit version installed

I can to suggest the report that will display office installed path + computer system type (x86/x64)

As a result the report will look like:

To determine what version of Office is installed(x86 or x64), you need to compare System Type and Path fields. For example:

If System Type is Win64 + Path is c:\Program Files (x86) = Office is x86

If System Type is Win64 + Path is c:\Program Files = Office is x64

If System Type is Win32 = Office is x86 anyway

Query:

SELECT DISTINCT t2.[Name] as 'Hostname', t2.[System Type], t2.[OS Name], t2.[OS Type], t0.[Publisher], t0.[DisplayName], t0.[DisplayVersion], t3.[Path]
FROM  Inv_AddRemoveProgram t0
    Join [vFixedAssetResourceStatus] t1 on t0._ResourceGuid = t1.Guid
    Join [Inv_AeX_AC_Identification] t2 on t1.Guid = t2._ResourceGuid
    join [Inv_Installed_File_Details] t3 on t2._ResourceGuid = t3._ResourceGuid
WHERE t0.DisplayName Not Like '%Service%' And t0.DisplayName Like 'Microsoft Office%'
    And t0.DisplayName Not Like '%Security%' And t0.DisplayName Not Like '%Project%'
    And t0.DisplayName Not Like '%Visio%' And t0.DisplayName Not Like '%Disc 2%'
    And t0.DisplayName Not Like '%Communicator%' And t0.DisplayName Not Like '%Viewer%'
    And t0.DisplayName Not Like '%Visual%' And t0.DisplayName Not Like '%Resource%'
    And t0.DisplayName Not Like '%Share%' And t0.DisplayName Not Like '%Publisher%'
    And t0.DisplayName Not Like '%proof%' And t0.DisplayName Not Like '%Powerpoint%'
    And t0.DisplayName Not Like '%outlook%' And t0.DisplayName Not Like '%onenote%'
    And t0.DisplayName Not Like '%live%' And t0.DisplayName Not Like '%infopath%'
    And t0.DisplayName Not Like '%frontpage%' And t0.DisplayName Not Like '%converter%'
    And t0.DisplayName Not Like '%access%' And t0.DisplayName Not Like '%web%'
    And t0.DisplayName Not Like '%excel%' And t0.DisplayName Not Like '%groove%'
    And t0.DisplayName Not Like '%word%' And t0.DisplayName Not Like '%interop%'
    AND t0.Publisher Like 'Microsoft%' and t0.[DisplayName] like 'Microsoft Office%'
    and t1.Status = 'Active' and t3.Name in('winword.exe')
ORDER BY  t2.Name