Incident creation if group does not have members or owners or managers

[Kaustubh k]

Hi @Viraj Hudlikar ,

This is in Continuation to the Solution which we discussed in the below link:

https://www.servicenow.com/community/incident-management-forum/incident-creation-ig-group-does-not-h...

I observed that whenever an existing case is already present in the system but does not have this group in the description, then also the system is not creating a case.

As we are just filtering with the short description.

Thanks,

[Ankur Bawiskar]

@Kaustubh k 

please share what debugging have you done so far and what's your latest script

[Kaustubh k]

@Ankur Bawiskar ,

Below is mine latest script:

var CheckEmptyGroups = Class.create();
CheckEmptyGroups.prototype = {
    initialize: function() {},
 checkGroups: function() {
        var gr = new GlideRecord('sys_user_group');
        gr.addActiveQuery();
        gr.query();
        
        var emptyGroups = new Set();
        
        while (gr.next()) {
            var groupId = gr.sys_id;
            var groupName = gr.name.toString();

            // Check if the group has members
            var memberCount = new GlideAggregate('sys_user_grmember');
            memberCount.addQuery('group', groupId);
            memberCount.addAggregate('COUNT');
            memberCount.query();
            memberCount.next();
            var hasMembers = memberCount.getAggregate('COUNT') > 0;

            // Check if the group has owners or managers
            var hasManager = gr.manager.toString() !== '';

            if (!hasMembers && !hasManager) {
                emptyGroups.add(groupName);
            }
        }
        
        if (emptyGroups.size > 0) {
            this.createIncident(Array.from(emptyGroups));
        }
    },

    createIncident: function(groupNames) {
        // Check if an incident already exists for these groups
        var existingIncident = new GlideRecord('incident');
        existingIncident.addQuery('short_description', 'Groups with no members & managers');
        existingIncident.query();
        if (existingIncident.next()) {
            return; // Incident already exists
        }

        // Create a new incident
        var inc = new GlideRecord('incident');
        inc.initialize();
        inc.short_description = 'Groups with no members & managers';
        inc.description = 'The following groups have no members or managers:\n' + groupNames.join('\n');
        inc.assignment_group = 'your_group_sys_id'; // Replace with the sys_id of the Admins group
        inc.insert();
    },

    type: 'CheckEmptyGroups'
};

[Ankur Bawiskar]

@Kaustubh k 

So how are you calling the above script and from where?

also if it's from scheduled job then it will only create 1 incident all the time, because you are checking if there is already an incident with that short description, if yes then don't create

better to add this check as well

// Check if an incident already exists for these groups
        var existingIncident = new GlideRecord('incident');
        existingIncident.addQuery('short_description', 'Groups with no members & managers');
existingIncident.addQuery('assignment_group', 'your_group_sys_id');
        existingIncident.query();
        if (existingIncident.next()) {
            return; // Incident already exists
        }

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Kaustubh k]

Hi @Ankur Bawiskar ,

Yes it is being called from scheduled job,

1 incident is getting created,but the issue is.

If that previous incident has the following description:

Group A

Group B

Group C

But after 1 day when the job runs again, we have another Group D ,which also does not have any members or managers.So,system should create a new incident with only Group D as the description,it should not include Group A,Group B,Group C.

But as in script we are just checking the short description,so system is not creating any other incidents also