Finding software updates in multiple packages

We have done several deployments of software updates in emergency situations where a software update package might contain the files for only one Article ID, such as a package for https://support.microsoft.com/en-us/help/4012598.  These files might also be contained in a second package with other updates, so the first package is no longer necessary… how can this be determined?

I took the Package ID for the software update package containing the one Article ID – XXX00BE9 and listed out the CI_IDs that package contains:

select su.CI_ID from fn_ListUpdateCIs(1033) as su

inner join vSMS_CIToContent as cc on su.CI_ID = cc.CI_ID

inner join vCI_ContentPackages as pc on pc.Content_ID = cc.ContentID

where pc.PkgID = N’XXX00BE9′

Then use that in a where clause to find other packages:

 

select

pc.PkgID

,su.CI_ID

,su.ArticleID

,su.BulletinID

,su.CI_ID

,su.Description

,su.DisplayName

,su.CIInformativeURL

from fn_ListUpdateCIs(1033) as su

inner join vSMS_CIToContent as cc on su.CI_ID = cc.CI_ID

inner join vCI_ContentPackages as pc on pc.Content_ID = cc.ContentID

where su.CI_ID in

(

select su.CI_ID from fn_ListUpdateCIs(1033) as su

inner join vSMS_CIToContent as cc on su.CI_ID = cc.CI_ID

inner join vCI_ContentPackages as pc on pc.Content_ID = cc.ContentID

where pc.PkgID = N’XXX00BE9′

)

Viola!  It’s in another package…

KB012598

SQL Profiler is a wonderful thing…

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s