Hi,
Maybe this will help you
select
dses.LastSeen
,enuser.DisplayName
,enuser.EmailAddress
,enuser.FirstName
,enuser.LastName
,enuser.UserName
from
dbo.device dev
,dbo.DeviceSession dses
,dbo.DeviceUserContext ducont
, mobileManagement.EnrollmentUser enuser
,dbo.DeviceUser duser
where
dev.CurrentSessionID = dses.DeviceSessionID
and dev.UnenrollmentDate is NULL
and ducont.DeviceID = dev.DeviceID
and dses.LastSeen > '2023-03-01'
and dev.DeviceID = ducont.DeviceID
and ducont.DeviceUserID = duser.DeviceUserID
and enuser.EnrollmentUserID = duser.EnrollmentUserID