Group Members has groups that no longer exist

[Robert Campbell]

When I look at the Group Members table, there are groups listed that no longer exist. Is there a way to clean this up?

I don't want to go through them one-by-one to find them. I was trying to do a report but if I choose Group Member as the table, I can't choose Groups as a related table because they don't relate "that way". If I choose Groups as the table, I can then choose Group Members as a related table but this is essentially a left join on Group's table. 

[Robert Campbell]

I think people are missing the fact that there "is" a sys_id.  The group that I'm pointing to does not exist but it shows in the list and it shows that it has a sys_id but when you click on it, it does not exist.

What I would like to do is compare grmember to group and show where in grmember but not in group. 

SELECT
  gm.group
FROM
  sys_user_grmember gm
LEFT JOIN
  sys_user_group g
ON
  gm.group = g.sys_id
WHERE
 g.sys_id is null;

The above view doesn't show me only the groups in grmember that aren't in groups.

[Siddhesh Gawade]

Hello @Robert Campbell , 

Let me know if your issue is resolved or not. Thank you!