BlackBerry® Enterprise Solution

[RobbieO]

We are running a small BES environment on v4.1.7 with 1726 users.

When an employee is terminated there are some automatic processes or workflow situations coming from HR using Peoplesoft that go through the system and start disabling or deleting the user's access from our systems.

Other systems include Active Directory, VPN and LDAP.

My group manually handles removing the users Notes account and their BES account.

Management is asking if there is a way to create an "interface" or something that runs automatically when coming from Peoplesoft, Active Directory etc that will disable/delete the user account on the BES.

They are looking for a script of some sort that could run.

Is this possible?  I am NOT a developer or programmer so my learning curve for this would be somewhat limited but would appreciate any suggestion or confirmation if this is possible.

Of course cannot have any disruption of normal BES server or usage.

Thanks!

RobbieO

[knottyrope]

you can drop user from database using the following:

1. Open command prompt
2. Type "osql -E"
3. 1>use BESMgmt
4. 2>go
5. 1>delete from userconfig where mailboxsmtpaddr=''user@domain.com''
6. 2>go


You might be able to make a script with this some how.

or maybe just install BlackBerry manager on their PC so they can delete the user, but they will be able to do more than just delete a user with the role.

Maybe setting up and testing BES 5 will be better as BAS is web based and easier to manage

[RobbieO]

KR
I have suggested upgrading to BES 5 but so far a no go.

Setting up BES manager with HR would not work either.

Would the command you kindly provided above work today if it were requested to delete a BES user? I process add/removes all the time on my BES server.

Thanks
Robbie

[knottyrope]

that command will drop a user from BES right away.

make a test account and delete it to see

[RobbieO]

hey, thanks for the help but this command did not work just keep getting error messages

[knottyrope]

what error messages?

[RobbieO]

osql -E is not a recognized as an internal or extermal command, operable program, or batch file is the error message.

i have no idea where i am supposed to be when running a command like this.

thank you.

[knottyrope]

I run it on teh BES itsefl, you will need to give permission for a remote connection to run it on a desktop.