Catherine_Tee
4 months agoNew Contributor III
User Overview Dashboard different time zone with System Security Logon time
There is different time zone between System - Security Logon time show 3.32pm (UTC+8) and in User Overview Dashboard show 7.32am (UTC). Possible synchronize showing same time zone which follow System - Security Logon time show 3.32pm into dashboard. Please advise how to update in dashboard.
The rule is
Select Name, Description, Email,LogonTime
--CONVERT(nvarchar, LogonTime, 110) as 'Logon Day'
--DATEDIFF(dd,LogonTime,GetUTCDATE()) AS 'Days since last Log on'
from secuser