Report to list all updates installed on Windows client computers.

book

Article ID: 180937

calendar_today

Updated On:

Products

Patch Management Solution for Windows

Issue/Introduction

 

Resolution

Please use the following SQL query to list all the updates installed on all clients.

-- to list all installed updates on clients with Bulletin Name
select vcx.Name, vcx.[IP Address], vsc.Name, vsb.Name, vsb.Description, vsc.Description
from Inv_Installed_Windows_Software_Update iiws (nolock)
join vSoftwareUpdate vsc on iiws.SoftwareUpdateGuid = vsc.Guid
inner join vComputerEx vcx on iiws._ResourceGuid = vcx.Guid
inner join vSoftwareUpdateInventoryRuleAssociations vsui on vsc.Guid = vsui.SWUGuid
inner join vPMCore_SoftwareBulletin Vsb on Vsb.Guid = vsui.SWBGuid
order by vcx.Name

-- to list all installed updates on clients with Bulletin Name [windows ONLY]
select vcx.Name, vcx.[IP Address], vsc.Name, vsb.Name, vsb.Description, vsc.Description
from Inv_Installed_Windows_Software_Update iiws (nolock)
join vSoftwareUpdate vsc on iiws.SoftwareUpdateGuid = vsc.Guid
inner join vComputerEx vcx on iiws._ResourceGuid = vcx.Guid
inner join vSoftwareUpdateInventoryRuleAssociations vsui on vsc.Guid = vsui.SWUGuid
inner join vPMCore_SoftwareBulletin Vsb on Vsb.Guid = vsui.SWBGuid
where vsc.Name like '%windows%'
order by vcx.Name

The same SQL can be used in a report to display results within SMP Console.