Today i read a question in the IBM Connections Forum about setting the EMPLOYEE_EXTENDED role to all users in a Connections deployment.
It would be easy to set it directly in the database, but that’s not supported by IBM.
I wrote a little script some weeks ago, because i had the same request, but never published it. The good thing here it only uses supported commands.
Here you see the source, it is simple a join of the tables emp_role_map and employee:
connect to peopledb;
EXPORT TO mail.txt OF DEL MODIFIED by NOCHARDEL
select e.PROF_MAIL FROM EMPINST.EMPLOYEE e
inner join EMPINST.EMP_ROLE_MAP r
Just call it with
db2 -tvf scriptname.sql.
The script exports a list of mail addresses of users without the specified role. This can then be used with the wsadmin command
Or as a oneliner:
wsadmin.bat -lang jython -c 'ProfilesService.setBatchRole(EMPLOYEE_EXTENDED, "mail.txt")'
Scheduling the two commands with Windows Scheduler or cron is enough to update all users to the specified role.
Documentation is provided in the script head.