Actually, with a little help from this post <http://sccmosd.blogspot.fr/2014/01/powershell-script-to-find-in-which.html> I was able to come up with a pretty simple WQL query. You were right that there was an intermediate step, but it was to tie it to a contentID not an update group.
"Select PKG.Name from SMS_SoftwareUpdatesPackage PKG join SMS_PackagetoContent P2C on P2C.PackageID = PKG.PackageID join SMS_CItoContent C2C on C2C.ContentID = P2C.ContentID where C2C.CI_UniqueID = '$CI_UniqueID'" ----- Dwayne Allen [email protected] (479) 310-0027 On Tue, Sep 16, 2014 at 10:31 AM, Daniel Ratliff <[email protected]> wrote: > I don’t think there will be, you will need to get the SUGs the software > update are in then tie that to the package. > > > > *Daniel Ratliff* > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Dwayne Allen > *Sent:* Tuesday, September 16, 2014 11:04 AM > *To:* [email protected] > *Subject:* [mssms] Identifying which deployment package a software update > is in > > > > Does anyone have a good WQL query for tying a software update to the > deployment packages it is in? I can't seem to find a class that ties them > together > > > > > ----- > Dwayne Allen > [email protected] > (479) 310-0027 > > > > The information transmitted is intended only for the person or entity to > which it is addressed > and may contain CONFIDENTIAL material. If you receive this > material/information in error, > please contact the sender and delete or destroy the material/information. > >
