This is a very basic approach to generate a list of groups that have a disabled user as the group owner (managedBy). SELECT g.managedby as GroupManagedBy, g.friendlyname as GroupFriendlyName, u.friendlyname as UserFriendlyName, u.AccountIsDisabled as UserDisabled FROM tblDomainGroup g JOIN tblDomainUser u on u.DistinguishedName = g.managedby WHERE u.AccountIsDisabled = 1