Add existing users to group through script

[J_31]

I want to add existing users to group and create a business rule to check if the user exist in the group if not add to the group

Please can someone help with script

[J_31]

Can we use glide aggregate script to assign the existing users to group? can you share if you write one?

[Hitoshi Ozawa]

Why use GlideAggregate to add 1 record?

GlideAggregate is use to query database table using aggregation such as using AVG, COUNT, MIN, MAX, STDDEV, SUM. It's not used to add record.

https://developer.servicenow.com/dev.do#!/reference/api/sandiego/server_legacy/c_GlideAggregateAPI

[Hitoshi Ozawa]

GlideAggregate is like SELECT... GROUP BY in sql. It's used to retrieve records but it's not possible to insert nor update records.

To assign user to a group in ServiceNow, it's necessary to insert a record into sys_user_grmember table. Since this is an insert operation, GlideAggregate can not be used. That is, GlideAggregate does not have .insert() nor .update() methods like GlideRecord.

If it's necessary to update multiple users at the same time. .updateMultiple() method in GlideRecord can be used.

https://developer.servicenow.com/dev.do#!/reference/api/sandiego/server_legacy/c_GlideRecordAPI#r_Gl...

[J_31]

I want to assign a role to the users who are in system_owner field in CMDB_CI table, So I thought i will add the existing users to a group and add a role to group, and when new record are created if the System_owner field has user assigned then we check for existing if not we will add new users to the group. 

I thought adding existing users to group we might need glide aggregate, I might be wrong. 

Please can you provide necessary script to achieve this

[J_31]

Its Owned_by field