Nice find! Daniel Ratliff
From: [email protected] [mailto:[email protected]] On Behalf Of Dwayne Allen Sent: Tuesday, September 16, 2014 11:53 AM To: [email protected] Subject: Re: [mssms] Identifying which deployment package a software update is in 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]<mailto:[email protected]> (479) 310-0027 On Tue, Sep 16, 2014 at 10:31 AM, Daniel Ratliff <[email protected]<mailto:[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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Dwayne Allen Sent: Tuesday, September 16, 2014 11:04 AM To: [email protected]<mailto:[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]<mailto:[email protected]> (479) 310-0027<tel:%28479%29%20310-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. 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.
