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, 05: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


Similar Threads
Thread Thread Starter Forum Replies Last Post
KB11490 - Out of Coverage Check hdawg Featured BlackBerry KB Articles 1 12-08-2009 01:03 AM
KB18473 - How to view DNS Host (A) and Pointer Resource Records (PTR) on MS DNS Srv hdawg Featured BlackBerry KB Articles 0 09-15-2009 08:06 PM
script to check logs habs3 Scripts & Tools / Hints & Tricks 8 09-13-2009 10:54 PM
NEEDED: SQL script bes users per exchange server RadHaz75 Scripts & Tools / Hints & Tricks 10 08-01-2009 08:48 AM
SQL script to find users' device free memory Joolie Scripts & Tools / Hints & Tricks 4 01-31-2009 09:44 AM


All times are GMT -4. The time now is 09:42 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2