Port3101.org : Your BES Connection

Port3101.org : Your BES Connection (http://www.port3101.org/index.php)
-   Scripts & Tools / Hints & Tricks (http://www.port3101.org/forumdisplay.php?f=12)
-   -   Script to show mising PIM Sync fields (http://www.port3101.org/showthread.php?t=2382)

Snapp 06-22-2010 10:52 AM

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

hdawg 06-22-2010 06:32 PM

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

THANK YOU! (y)


All times are GMT -4. The time now is 02:10 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


SEO by vBSEO 3.3.2 PL2