[mssms] SQL query software update in what deployment package

[SCCM FUN]

Anyone have a query or is there some report I'm not seeing to determine what 
deployment package a certain software update is in?
Thanks