Adding groups to existing SIMS users (x148)

[ial]

Hi,

 

I need to go through all our hosted schools and add a group to our EWO's. As there are something in the region of 148 schools hosted here, I was hoping I could find and modify an SQL script to run in the SQL management studio rather than troll through each one in turn.

 

Thanks in advance

Edited July 29, 2014 by ial

[matt40k]

A script wouldn't exist in the public domain. It'll be a paid for one-time patch by Capita if it does. Even then are you sure all the users\groups are called the same? Not sure it'll be worth the effort using the Business Objects for that few.