I am trying to figure out how to get this figured out.
Users of inactive customers are receiving scheduled maintenance notifications
- Organizations have a custom binary field to indicate if they are Active
- Users have two binary fields to indicate if they can access the system
- Identify any users that have their Active and/or CanLogIn values set to 1 AND
- Are associated by OrganizationID to an Organization with the custom Active field set to 0 (zero)