-- This view is not used anymore but remains for customer integration
create view v_customerGrpMemberHistory as
select gej.groupID, sej.sessionID, us.userID, eh.eventEpoch, eh.eventType,
            case when eh.eventType = 5 then N'false' else N'true' end isJoin
from GroupEventJoin gej inner join
    EventHistory eh on gej.eventID = eh.eventID inner join
    SessionEventJoin sej on eh.eventID = sej.eventID inner join
    UserSessions us on us.sessionID = sej.sessionID and us.userID not in (select distinct userID from Roles r inner join UserRoleJoin urj on r.roleID = urj.roleID where r.isAgent=1)
                                    and eh.eventType in (4,5,11)


GO