Hello team,
I need your help again with the following issue:
I need to run a monthly report on all the users in a system and I need to flag all/any user that has both active roles and it's deactivated. The only workaround I found is to use the Summarize (group by username) and concatenate the users' roles and then filter for each user that is both deactivated and has active role. However, I never know how many users will actually be in this situation. For example, I found only one user this month that has both an active role and his acct was already inactive. But it may be more than one.
Is there an easier way to do this?
Thank you!
Kind regards,
Ioana
