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



Reply
LinkBack Thread Tools Display Modes
Script to show mising PIM Sync fields
 
  #1 (permalink)  
Old 06-22-2010, 10:52 AM
BES Activated
 
Join Date: Feb 2009
Location: DE
Posts: 3
Default Script to show mising PIM Sync fields

I work in a Domino shop and we had received calls in the past saying address books aren't syncing. Well 9 times out of 10 its due to missing server and relative path information under PIM Sync. So when you run this script it will only return the users that are missing the the info. It is also displayed so you can easily copy/paste it into the users PIM Sync fields....

select uc.DisplayName,
uc.UserName,
uc.ServerDN,
uc.MailboxDN,
sdbt.Name,
svrc.ServiceName from UserConfig uc
inner join SyncConfig sc on sc.UserConfigId=uc.Id
inner join SyncDbType sdbt on sc.SyncDbTypeId=sdbt.Id
inner join ServerConfig svrc on svrc.Id=uc.ServerConfigId
where (sc.SyncDbTypeId = 25418 or sc.SyncDbTypeId = 28675) and sc.Location = ''
order by uc.DisplayName, sdbt.Name
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-22-2010, 06:32 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

excellent post! I was actually working with a customer last week that this will be perfect for.

THANK YOU!
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
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
Balloon Boy Pukes on The Today Show Otto Off-Topic Discussion 6 08-17-2010 09:13 AM
KB10395 - Changing the default view of the messages list to show only enterprise ... hdawg Featured BlackBerry KB Articles 0 08-22-2009 02:30 PM
KB16033 - Relative Path fields for PIM Sync are blank when users are moved hdawg Featured BlackBerry KB Articles 0 05-26-2009 05:50 PM
Show the load on the server for pending data packets Marcus Port 3101: The BES Admin Bar & Grill 5 02-06-2009 05:34 PM


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


 

SEO by vBSEO 3.3.2 PL2