A recently reimaged system with Cloud-Enabled Management (CEM) agent installed (as part of the image) is not registering with the Notification Server and it seems to be an issue with a certificate, but it wasn’t quite know which certificate was causing the issue.
ITMS 8.6 RU2
Resource Association exists, and not a CEM certificate.
Running the query below will remove the Resource Associations that need to be cleaned up in order to register with the SMP:
delete RA from [ResourceAssociation] RA
left join Inv_Digital_Certificate_Details dcd on RA.[ChildResourceGuid] = [dcd]._ResourceGuid
where ([ResourceAssociationTypeGuid] = 'fd859758-beca-4cac-992f-555803651c0d' or [ResourceAssociationTypeGuid] = 'd2c3dacc-5e96-4d23-b39b-87dca7b74533')
and [dcd]._ResourceGuid is null