04-26-2012 10:01 AM
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.
04-26-2012 10:14 AM
you can drop user from database using the following:
1. Open command prompt
2. Type "osql -E"
3. 1>use BESMgmt
5. 1>delete from userconfig where firstname.lastname@example.org''
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
04-26-2012 10:31 AM
04-26-2012 10:44 AM
that command will drop a user from BES right away.
make a test account and delete it to see
05-02-2012 02:59 PM
what error messages?
05-04-2012 08:34 AM
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.
05-04-2012 10:33 AM
I run it on teh BES itsefl, you will need to give permission for a remote connection to run it on a desktop.