Exclude suspended/deactivated users

Exclude suspended/deactivated users

by Charlie Oliver Ng -
Number of replies: 2
I noticed that even though I suspend user profiles, they still appear in the group they are part of and thus appears on the completion reports generated.

Is there a way to exclude suspended profiles without having to (manually) remove them from the groups?

Thanks!


Average of ratings: -
In reply to Charlie Oliver Ng

Re: Exclude suspended/deactivated users

by Steven Swanson -

In the filter tab on top choose user profile or data (don't remember which) then choose suspended = 0. If it is an SQL report the go to custome SQL tab and add "WHERE u.suspended=0".  I think that should work.

In reply to Steven Swanson

Re: Exclude suspended/deactivated users

by Charlie Oliver Ng -

Thanks Steven! I managed to insert the code (I think), I'll observe what happens in the next 24hrs.

Cheers!