Location MD History

select convert(char,convert(datetime,A.CreatedOn at time zone 'UTC' at time zone 'Central Standard Time (Mexico)'),120)CreatedOn,
    A.ClientId,B.ClientName,SubClientName,SubClientCode,LocationStatus,Customer,CustomerName,a.UserName AS CreatedBy,LocationClusterName,LocationClusterCode,LocalClusterName,LocalClusterCode,IsProcessed,*
    from LocationMDHistory A with (nolock)
    inner join Client B with (nolock) on A.ClientId=B.ClientId
    where A.ClientId = 228 and A.CreatedOn >= '2025-01-27' --and UserName IN ('DCHTC') 
    order by A.Customer asc

Select convert(char,convert(datetime,A.CreatedOn at time zone 'UTC' at time zone 'Central Standard Time (Mexico)'),120)CreatedOn,
a.UserName AS CreatedBy,
A.ClientId,B.ClientName,A.FirstName,A.LastName,A.UPN,A.UserID as Username,A.Password,A.Email,A.Phone,A.Role,A.Country,A.SubClientCode,A.IsActive,A.ReportingManager,A.SSO,A.UserName
from UserMDHistory A with (nolock)
 inner join Client B with (nolock) on A.ClientId=B.ClientId
 where A.ClientId = 228 and A.CreatedOn >= '2025-01-27' order by A.CreatedOn asc

Select * from UserLocationMd a where a.Username = 'pedro.gavilanes@arcacontal.com'

--------------------------------------------------