CRM 4.0 to D365 CE upgrade
We are trying to upgrade CRM 4.0 to D365 CE. Part of the process is to establish the last login of CRM Users. We have tried the query below in the CRM 4.0 database but it is not returning the values we want.
select us.FullName, max(a.CreatedOn) as LastLoginDate from Audit a
inner join SystemUser us on a.ObjectId = us.SystemUserId
a.Operation = 4 and us.IsDisabled = 0
group by us.FullName