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