How to check what Deployment Package an update belongs to

Hi,

this might be a simple question but I can't find my way around it :)

How can I check what Deployment Package an update belongs to? For instance, a colleague set up a Software Update Group a year ago or so to deploy Internet Explorer 11 for Windows 7. Now, we don't have any Deployment Package called IE 11 or so, I know that this update is in the Windows 7 Updates Deployment Package because I thought that might be the only place where to find it. 

  1. If I right click > Download and choose another Deployment Package, will SCCM duplicate my update? (I guess it will).
  2. If the answer to 1 is yes, how can I list all of the Deployment Packages a single update is downloaded to?

Thanks

August 17th, 2015 8:20am

  1. On the package source location, yes;
  2. You could use PowerShell, for example: https://gallery.technet.microsoft.com/Show-memberships-of-404936a8
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2015 8:24am

select vui.ArticleID, vui.Title, p.Name, P.Description

from dbo.vUpdatetopkg as vutp

join dbo.v_updateinfo as vui on vui.ci_id=vutp.ci_id

join dbo.v_package as p on p.PackageID=vutp.PkgID

where vui.ArticleID='Insert a KB Article Number here, without the KB, like 3337777'

The above won't show you a "single" update per se--a KB articleID might have 10 things for it, for different versions of IE or different versions of the OS for example--but looking at Title you would differentiate that.

August 17th, 2015 8:27am

The script is great Dankje! :)

Just for your information, the Example you reported in gallery.technet, under -SiteServer there's a typo in the example (comma rather than dot in the fqdn).

Cheers

Free Windows Admin Tool Kit Click here and download it now
August 17th, 2015 8:41am

Thanks! I just adjusted the typo.
August 17th, 2015 8:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics