Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
SQL Script - Check users with TimeZone records on their devices
 
  #1 (permalink)  
Old 11-17-2010, 04:01 AM
noname's Avatar
BES Administrator
 
Join Date: Apr 2009
Location: Congested Islet of Foreign Talents (42% of population) - Singapore.
Posts: 24
Arrow 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
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 03:48 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2