Groups that have been deleted from ServiceNow.
The group listed in sys_user_grmember does not exist in sys_user_group. Not sure how that happened but this is the scenario.
If I go to "Group Members" and click on the group, I get
Can you apply a filter in the table as below:-
group.name is empty and see what result it throws back since there is no record it can query with it should return the deleted groups
If this does not work let me know.
Please mark my answer as correct based on Impact.
Hello,
So as you can see it did not return anything which means the group is not present so it is not possible to access the field also on the group table.
Now a easy way base don the screenshot when you apply filter group is empty it gives you the list of records with the group value as empty is that correct.
If yes, then after the filter is applied just select all the records returned and from the action select delete. it will delete the records in one go.
Please mark my answer as correct based on Impact.
No. Looking for where the group value is empty is not giving the proper results. On the sys_user_grmember table, the group exists as well as the users that are supposed to be in that group. However, when you click on the group name, you get that error I shared.
I'm trying to get a list of those records on the sys_user_grmember table that shows a group that doesn't actually exist.
The above groups don't actually exist. They may have existed at some point but they no longer exist. Some others below may also not exist anymore. I want a way to get a list of these groups that don't actually exist anymore even though there is a record of them in the sys_user_grmember table.
