-- Show bulletin, update, updatepolicy, and applicability data
select distinct b.[Guid] as [BulletinGuid], b.name as [BulletinName], ia.Enabled ,u.Guid as [UpdateGuid],u.name as[UpdateName],
       swUpdatePol.Guid as [UpdatePolicyGuid], swUpdatePol.Name as [UpdatePolicyName], ia2.Enabled,
       r.Name as [UpdateAppliesTo]
from [dbo].[RM_ResourceSoftware_Bulletin] b
Join ResourceAssociation ra on b.Guid = ra.ParentResourceGuid
       and ra.ResourceAssociationTypeGuid = '7EEAB03A-839C-458D-9AF2-55DB6B173293' --Software Bulletin To Software Update
Join RM_ResourcePatch_Software_Update u on ra.ChildResourceGuid = u.Guid
LEFT JOIN ItemReference ir on u.guid = ir.ChildItemGuid
       and ir.Hint = 'policy_swu'
LEFT JOIN Item swpolicy on ir.ParentItemguid = swpolicy.guid
LEFT JOIN ItemActive ia on swpolicy.guid = ia.Guid --and ia.Enabled = 1
LEFT JOIN ItemReference ir2 on u.guid = ir2.ChildItemGuid
       and ir2.Hint = 'swu'
LEFT JOIN Item swUpdatePol on ir2.ParentItemguid = swUpdatePol.guid
LEFT JOIN ItemActive ia2 on swUpdatePol.guid = ia2.Guid --and ia2.Enabled = 0
LEFT JOIN ResourceAssociation ra2 on u.Guid = ra2.ParentResourceGuid
       and ra2.ResourceAssociationTypeGuid = '9603714F-078D-4B85-989D-81FC23ABF397' -- Software Update Applies To Software Release
Join RM_ResourceSoftware_Release r on ra2.ChildResourceGuid = r.Guid
Where b.name = 'MS15-059'