[big.phil]

I came across a couple threads asking if this is possible and havent seen any good way to sync mobile numbers from BES to Active Directory accounts. So...I created a little app that will sync the users BES mobile number with their Active Directory account "mobile" attribute. I have tested this on BES 5.0 for Microsoft Exchange in a Windows 2008 AD environment and all works great. It should work with older versions of BES but test it in "manual" mode first to verify. Two modes of operation, Manual or Automatic. View the ReadMe.txt file for information on how to configure it!

[big.phil]

Also...do not use a trailing "/" in the LdapPath application setting or it will throw the following error: "Error: Unknown error (0x80005000)". I will trap for this in the next build.

If anyone finds a bug or has a feature request, let me know!

[pumbaa70]

For some reason I keep on getting this error

9/22/2010 4:15:06 PM - Error: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.


Here is my aconfig

<add name="BEStoADsync.My.MySettings.BESConnectionStrin g" connectionString="Data source=BES02\BLACKBERRY;Initial Catalog=BESMgmt;Integrated Security=sspi" />

[big.phil]

I am unable to reproduce this error. Have you tried running the app from a different computer? also...is the .NET Framework up to date and running the .NET Framework client profile 4.0? I have also attached the latest build that corrects the issue from post #2.

[pumbaa70]

I tried unzipping again and got to work not sure what happened. But it doesnt find all the BES Numbers in the database even though they are there it only got some of them any ideas

[big.phil]

i might have an idea, but not quite sure. can you run the following two queries in sql and report back the numbers?
"select count(*) from syncdevicemgmtsummary"
"select count(*) from userconfig"

also...if you find a user that is missing the number in the app, but its showing correctly in the BES database, can you PM me a txt file with all of the data in each of the two tables mentioned above for the user in question? this would help in figuring out what is causing the issue in your environment.

[pumbaa70]

114
114

Can we do private email if I am going to exchange better

[big.phil]

updated version of the app (1.0.0.2). Fixes an issue were mobile numbers might not be populated correctly from the BES database. It is recommended for anybody that is using an older version to run the new version and resync all user accounts.

[big.phil]

updated version (1.0.0.3). Adds the ability to exclude any account from syncing to Active Directory in manual or automatic mode.

If a mod could delete the older attachments in this thread, that would be cool. I cant edit anything old nor delete attachments.

[TargetIT]

I'm more of a scripting guy and came up with this:

setlocal ENABLEDELAYEDEXPANSION
sqlcmd -U "username" -P "password" -S "servername\instance" -d besmgmt -Q "set nocount on SELECT RIGHT(dbo.SyncDeviceMgmtSummary.PhoneNumber, 10) AS Expr1, dbo.UserConfig.DisplayName FROM dbo.SyncDeviceMgmtSummary INNER  JOIN dbo.UserConfig ON dbo.SyncDeviceMgmtSummary.UserConfigId = dbo.UserConfig.Id WHERE (RIGHT(dbo.SyncDeviceMgmtSummary.PhoneNumber,10) <> N'')" -o Output.txt -W -h -1
for /f "tokens=1*" %%i in (output.txt) do (
	set PhoneNumber=%%i
	set PhoneNumberFormatted=^(!PhoneNumber:~0,3!^) !PhoneNumber:~3,3!-!PhoneNumber:~6!
	find "%%j" SupressList.txt
	if errorlevel 1 dsquery user -name "%%j" | dsmod user -mobile "!PhoneNumberFormatted!"
)

It's not quite as slick for some obvious reasons, but it works. There's a supresslist.txt file that will prevent some names/numbers from being published (a requirement we had).

[big.phil]

always good to have more ways of doing the same thing