Back to FAQ library

What are some queries that I can use to investigate my Identity Resolution results?

  • Check out these new queries from official docs! In addition, you may find these useful (modify as necessary):
Sql
-- Find the top 10 Unified Individual records
WITH UnifiedIndividualLinkCounts AS (
  SELECT
      UnifiedRecordId__c,  
      COUNT(*) AS NumberOfLinkedRecords 
  FROM
      IndividualIdentityLink__dlm   
  GROUP BY
      UnifiedRecordId__c
)
SELECT
  uilc.NumberOfLinkedRecords,
  ui.ssot__Id__c,         
  ui.ssot__PersonName__c, 
  ui.ssot__FirstName__c, 
  ui.ssot__LastName__c,   
  ui.Date_of_Birth__c                    
FROM
  UnifiedIndividual__dlm AS ui 
JOIN
  UnifiedIndividualLinkCounts AS uilc 
ON
  ui.ssot__Id__c = uilc.UnifiedRecordId__c 
ORDER BY
  uilc.NumberOfLinkedRecords DESC
LIMIT 10; 
Sql
-- Find the associated Individual, CP Email, and Party ID records for a given Unified Individual ID
SELECT
  i.ssot__FirstName__c,
  i.ssot__LastName__c,
  i.Date_of_Birth__c,
  i.ssot__DataSourceObjectId__c, 
  pi.ssot__IdentificationNumber__c,
  pi.ssot__Name__c, 
  pi.ssot__PartyIdentificationTypeId__c, 
  cpe.ssot__EmailAddress__c AS EmailAddress
FROM
  IndividualIdentityLink__dlm AS iil 
JOIN
  ssot__Individual__dlm AS i ON iil.SourceRecordId__c = i.ssot__Id__c
LEFT JOIN
  ssot__PartyIdentification__dlm AS pi ON i.ssot__Id__c = pi.ssot__PartyId__c
LEFT JOIN
  ssot__ContactPointEmail__dlm AS cpe ON i.ssot__Id__c = cpe.ssot__PartyId__c
WHERE
  iil.UnifiedRecordId__c = 'DESIRED_UNIFIED_INDIVIDUAL_ID';

Diagram