USP_EMAIL_GETCONFIGURATION

Retrieves email service configuration data.

Parameters

Parameter	Parameter Type	Mode	Description
@SITEID	int	IN

Definition

Copy



      CREATE procedure dbo.USP_EMAIL_GETCONFIGURATION
      (
        @SITEID integer
      )
      as
      begin
          exec dbo.USP_GET_KEY_ACCESS;

        begin try
          select NAME, VALUE, DATECHANGED from dbo.EXTERNALSERVICECONFIGURATION
            where SITEID = @SITEID and NAME in ('BlackbaudServiceHost','BlackbaudServiceUseSecureServices','EmailServiceBinding', 'UseSharedServicesCommunicationService', 'EmailServiceTransactionalPath','EmailServiceGeneralPurposePath','EmailServiceStatusPath')

          union all

          select NAME, decryptbykey(VALUE) 'VALUE', DATECHANGED from dbo.EXTERNALSERVICECONFIGURATION
            where SITEID = @SITEID and NAME in ('BlackbaudServiceUser','BlackbaudServicePassword');

          close symmetric key sym_BBInfinity;
        end try
        begin catch
          close symmetric key sym_BBInfinity;
        end catch

      end