A recently reimaged system with 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 don’t quite know which certificate is causing the issue.
Resource Association exists, but not a CEM certificate.
Run 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