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

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

THANK YOU!

__________________
http://blog.port3101.org/hdawg/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.