Gotcha. The following should work:
- Create a new business rule on Knowledge Base (kb_knowledge_base)
- Set the Order to 1 or something lower than 100 where OOB business rules execute and add roles to the users
- Set condition to Managers changes and Managers is not empty:
Then on the advanced tab the following script. I made an assumption you are utilizing the OOB "Certification" role so the SysID should work. But feel free to modify the errorMessage variable to your liking.
(function executeRule(current, previous /*null when async*/) {
var errorMessage = "The ServiceNow Access form needs completed for the following user(s): ";
var userNames = [];
var managerList = current.kb_managers.toString().split(",");
for (var i = 0; i < managerList.length; i++) {
// Search the User Role table for roles assigned to each manager. Filtering out the "Certification" role.
// If no additional roles are found, add the user's name to the userNames variable and abort update.
var userRole = new GlideRecord("sys_user_has_role");
userRole.addQuery("user", managerList[i]);
userRole.addQuery("role", "!=", "ba4509c60a00070400cc0f3a60a0d30a"); //Certification
userRole.query();
if (!userRole.hasNext()) {
var userRec = new GlideRecord("sys_user");
userRec.get(managerList[i]);
userNames.push(userRec.getDisplayValue());
}
}
if (userNames.length > 0) {
errorMessage += userNames.toString();
gs.addErrorMessage(errorMessage);
current.setAbortAction(true);
}
})(current, previous);
Please mark this post or any as helpful or the correct answer to your question if applicable so others viewing may benefit.
