--New Applicaiton/ draft Step 1-5
select top 1 idno, * from mos_customer.CustomerOnboarding WITH (NOLOCK)
where Name like '%iman%' order by CreatedAt desc
--New Application/ draft Step 6 - 17
select top 10 * from mos_log.EKYCRequestLog WITH (NOLOCK) where body like '%000511100303%' order by CreatedAt desc--Body like '%EKYCCert_6db7e087-e895-42cf-9c89-9c19c9291ef4%'
select top 1 * From mos_log.EKYCCallbackLog WITH (NOLOCK) where CreatedAt > '2026-03-11'
AND Body like '%EKYCCert_f80e3e53-c81f-4544-8f42-6169ab605ef4%'