Custom Report for Microsoft Office Service Packs

book

Article ID: 178907

calendar_today

Updated On:

Products

Patch Management Solution for Windows

Issue/Introduction

 

Resolution

Microsoft Office Service Packs (SP's) are deployed as microsoft patches in SBSP bulletins in Patch Management. The following SQL query uses data collected by Patch Management to list which computers have which Microsoft Office Service Packs. To use the query go to Manage>Reports, right-click on a folder, select New>Report>SQL Report, paste the query in the Parameterized Query box over the default query, then name the report and click Save Changes. Keep in mind that the report will get outdated as new service packs come out, that computers can have multiple versions of Microsoft Office (different components from each), and that the report will not list computers that have Microsoft Office without a service pack. Symantec Support does not support custom reports so further modifications must be made by the user.

SELECT
vComputer.Name [Computer],
vComputer.[User],
vComputer.[OS Name],
vComputer.[OS Revision],
vComputer.[System Type] AS [OS Bit Level],
CASE vSU.[Name]
when 'office2010sp1-kb2460049-fullfile-ENU.exe' then 'Office 2010 SP1'
when 'office2010sp1-kb2460049-x64-fullfile-ENU.exe' then 'Office 2010 x64 SP1'
when 'officesp2010-KB2687455-fullfile-ENU.exe' then 'Office 2010 SP2'
when 'officesp2010-kb2687455-fullfile-x64-ENU.exe' then 'Office 2010 x64 SP2'
when 'proplussp2013-kb2817430-fullfile-x86-ENU.exe' then 'Office 2013 SP2'
when 'proplussp2013-kb2817430-fullfile-x64-ENU.exe' then 'Office 2013 x64 SP2'
when 'office2007sp3-kb2526086-fullfile-ENU.exe' then 'Office 2007 SP3'
when 'office2007sp2-KB953195-fullfile-ENU.exe' then 'Office 2007 SP2'
when 'office2007sp1-KB936982-fullfile-ENU.exe' then 'Office 2007 SP1'
when 'office2003SP3-KB923618-FullFile-ENU.exe' then 'Office 2003 SP3'
when 'Office2003SP2-KB887616-FullFile-ENU.exe' then 'Office 2003 SP2'
ELSE vSU.Name END AS [Office Version/Bit Level/SP Level]
FROM vComputer
Left JOIN Inv_Installed_Windows_Software_Update iSU on iSU._ResourceGuid = vComputer.Guid
left join vSoftwareUpdate vSU on vSU.Guid = iSU.SoftwareUpdateGuid
WHERE (vSU.Name like '%KB2460049%'
OR vSU.Name like'%KB2687455%'
or vSU.Name like '%KB2817430%'
or vSU.Name like '%KB2526299%'
or vSU.Name like '%KB2526086%'
or vSU.Name like '%KB953334%'
or vSU.Name like '%KB936984%'
or vSU.Name like '%KB953195%'
or vSU.Name like '%KB936982%'
or vSU.Name like '%KB923618%'
or vSU.Name like '%KB887616%'
or vSU.Name like '%KB842532%')
Order by vComputer.Name, [Office Version/Bit Level/SP Level]