USP_EXCHANGEINTEGRATION_GETUNMAPPEDAPPUSERS

Returns a list of application users that have not been mapped to an exchange server.

Definition



            CREATE procedure dbo.USP_EXCHANGEINTEGRATION_GETUNMAPPEDAPPUSERS
            as
                set nocount on;

                select
                    ID,
                    USERSID,
                    dbo.UFN_APPUSER_GETNAME(APPUSER.ID) as USERNAME
                from
                    dbo.APPUSER
                where    
                    APPUSER.ID not in(select EXCHANGESERVERAPPUSER.APPUSERID from dbo.EXCHANGESERVERAPPUSER);