Hi Hector,
thank you for your reply. Actually, me problematic environment is OnPrem, version 8.1 and currently PROD. I didn't replicate issue on my DEV environment.
Anyway, I have at least DB readonly view to customer database. So I've uses SQL select to check emailsearch table instead your recomended URL.
declare @checkemail varchar(100) = '%Katarina.Petkacova%'; this is on of missing CC recipients, ContactA1(email: user_a@email.sk)
select 'emailsearch', es.EmailSearchId, es.EmailAddress, es.EmailAddress, null, null
from emailsearch es
where (es.EmailAddress like @checkemail)
union
select 'Account', a.AccountId, a.Name, ISNULL(a.emailaddress1, 'null') + ' ' + ISNULL(a.emailaddress2, 'null') + ' ' + ISNULL(a.emailaddress3, 'null'), a.ModifiedOn, a.createdon
from Account a
where (a.emailaddress1 like @checkemail or a.emailaddress2 like @checkemail or a.emailaddress3 like @checkemail)
union
select 'Contact', c.ContactId, c.FullName, ISNULL(c.emailaddress1, 'null') + ' ' + ISNULL(c.emailaddress2, 'null') + ' ' + ISNULL(c.emailaddress3, 'null'), c.ModifiedOn, c.createdon
from Contact c
where (c.emailaddress1 like @checkemail or c.emailaddress2 like @checkemail or c.emailaddress3 like @checkemail)
union
select 'Lead', l.leadId, l.FullName, ISNULL(l.emailaddress1, 'null') + ' ' + ISNULL(l.emailaddress2, 'null') + ' ' + ISNULL(l.emailaddress3, 'null'), l.ModifiedOn, l.createdon
from Lead l
where (l.emailaddress1 like @checkemail or l.emailaddress2 like @checkemail or l.emailaddress3 like @checkemail)
union
select 'Queue', q.QueueId, q.Name, q.emailaddress, q.ModifiedOn, q.createdon
from Queue q
where (q.emailaddress like @checkemail ) -- 232C5DB6-50D9-E911-80F2-005056A78F71
union
select 'mailbox', m.mailboxId, m.Name, m.emailaddress, m.ModifiedOn, m.createdon
from mailbox m
where (m.emailaddress like @checkemail )
union
select 'Team', t.TeamId, t.Name, t.emailaddress, t.ModifiedOn, t.createdon
from Team t
where (t.emailaddress like @checkemail)
union
select 'BusinessUnit', bu.BusinessUnitId, bu.Name, bu.emailaddress , bu.ModifiedOn, bu.createdon
from BusinessUnit bu
where (bu.emailaddress like @checkemail)
union
select 'SystemUser', s.SystemUserId, s.FullName, ISNULL(s.internalemailaddress, 'null') + ' ' + ISNULL(s.personalemailaddress, 'null') + ' ' + ISNULL(s.sharepointemailaddress, 'null') + ' ' + ISNULL(s.yammeremailaddress, 'null'), s.ModifiedOn, s.createdon
from SystemUser s
where (s.internalemailaddress like @checkemail or s.personalemailaddress like @checkemail or s.sharepointemailaddress like @checkemail or s.yammeremailaddress like @checkemail)
union
select 'unresolvedaddress',ua.UnresolvedAddressId, ua.FullName, ua.EmailAddress, null, null
from unresolvedaddress ua
where (ua.EmailAddress like @checkemail)
returns 2 rows, 1.. contact, 2.. emailsearch
(No column name) EmailSearchId EmailAddress EmailAddress (No column name) (No column name)
emailsearch 34BF5195-868A-E811-80E2-005056A7775C Katarina.Petkacova@immorent.com Katarina.Petkacova@immorent.com NULL NULL
Contact 2EBF5195-868A-E811-80E2-005056A7775C Katarina.Petkacova@immorent.com Katarina.Petkacova@immorent.com null null 2018-07-18 12:32:10.000 2018-07-18 12:32:10.000
So email address is present in EmallSearch and ONLY 1 record in ContactEntity.. Does CRM care about lower, upper case in email address? Or do you have any other idea?
Thank you
David Svoboda
Share
Report
20
All responses (
Answers (
