CEM systems that are reimaged are not able to register with the SMP again after imaging.

Products

• Client Management Suite
• Deployment Solution

Issue/Introduction

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.

 

Environment

8.6 RU2

Cause

Resource Association exists, but not a CEM certificate.

Resolution

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