SQL Script - Check users with TimeZone records on their devices
Run this to check how many users have the updated TimeZone records on their devices. For users not listed in the results, that means the updated TimeZone records are not sent to the device by the BES Sync Server and potentially they may have DST issue.
SELECT count(*) as TZRecords, UserConfigId, DisplayName, ServerConfigId
FROM SyncDeviceUserState
INNER JOIN UserConfig
ON SyncDeviceUserState.UserConfigId = UserConfig.Id
WHERE State=1 and SyncDBTypeId=15403
GROUP BY UserConfigId, DisplayName, ServerConfigId
ORDER BY ServerConfigId, UserConfigId
__________________
【noname】- Native but 3rd class citizen of a nation governed by idiots who import congestions and contention.
BlackBerry® Certified Solution Designer + System Administrator
IBM Certified Advanced Application Developer + Associate System Administrator - Lotus Notes and Domino
|