Oct 17, 2017

All users log-in and log-out time history in ax 2012 (AX의 모든 유저의 접속 히스토리)

SELECT T1.USERID AS 'USERID',
T1.CREATEDDATETIME AS 'LOGINDATETIME',
T1.LOGOUTDATETIME AS 'LOGOUTDATETIME'
FROM SYSUSERLOG AS T1
WHERE T1.USERID != '-AOS-'
ORDER BY T1.CREATEDDATETIME

No comments:

Post a Comment