SELECT w.auth_CustFldr, w.auth_AppName, w.auth_LoginSecureIDs, w.auth_ReminderSiteName, w.auth_ReminderFromAddy, w.auth_LoginHelpAddy, c.FSL_CompanyID, c.FSL_TableCode, w.websiteid, w.auth_GenericBrokerPortalLogin FROM fsenablers..tbl_CUS_Websites w, fsenablers..tbl_CUS_Customers c WHERE w.portal_ownerId = and w.portal_ownerType = AND w.CustomerID = c.CustomerID select attrbId LoginAreaID from tbl_SEC_Attributes with (nolock) where ownerId = and fsl_tablecode = and attrbTypeId = 3 and attrbId = select fspro_userId, firstName, lastName, ownerId, fsl_tablecode from tbl_Fspro_members with (nolock) where ownerId = and fsl_tablecode = and email = and loginEnabled = 1 update tbl_Fspro_members set fspro_password = , fspro_password_method = , passwordLastChangeDate = where fspro_userId = and ownerId = and fsl_tablecode =

Your one-time password is: #htmleditformat( _oneTimePassword )#

select fspro_UserId, passwordLock from tbl_fspro_Members with (nolock) where email = and ownerId = and fsl_tablecode = and loginEnabled = 1 declare @loginMFAEnabled bit = ( select cast( coalesce( loginMFAEnabled, 0 ) as bit ) as loginMFAEnabled from tblManufacturers with (nolock) where mfr_id = ); select changePasswordRequired, @loginMFAEnabled as loginMFAEnabled from tbl_fspro_members with (nolock) where fspro_userId = and ownerId = and fsl_tablecode = declare @loginMFAEnabled bit = ( select cast( coalesce( loginMFAEnabled, 0 ) as bit ) as loginMFAEnabled from tblBrokers with (nolock) where broker_id = ); select changePasswordRequired, @loginMFAEnabled as loginMFAEnabled from tbl_fspro_members with (nolock) where fspro_userId = and ownerId = and fsl_tablecode = select changePasswordRequired, cast( coalesce( loginMFAEnabled, 0 ) as bit ) loginMFAEnabled from tbl_fspro_members with (nolock) where fspro_userId = and ownerId = and fsl_tablecode = update tbl_Fspro_members set fspro_password = , fspro_password_method = , changePasswordRequired = null, passwordLastChangeDate = where fspro_userId = and fspro_password = and = update tbl_fspro_members set loginMFACode = , loginMFAExpiration = where fspro_userId = and ownerId = and fsl_tablecode = select email from tbl_FSPRO_Members where fspro_userId = and ownerId = and fsl_tablecode =

Here is your security code to continue signing in to your TELUS Sales Enablement Sales Team Portal:

#encodeforHTML( _loginMFACode )#

This code will expire in #lsnumberformat( _mfaExpirationMinutes )# minutes.

If you did not attempt to sign in, please ignore this email or contact our support team immediately.

Thanks,
The TELUS Team

update tbl_fspro_members set loginMFACode = null where fspro_userId = select clientSTPAdminUser from tbl_FSpro_members where fspro_userId = update tbl_fspro_members set passwordlock = 0 where fspro_userid = select fspro_UserId, passwordLock from tbl_fspro_Members with (nolock) where email = and ownerId = and fsl_tablecode = and loginEnabled = 1 select count(*) as attempts from tbl_TRK_MemberActivity with (nolock) where cfid_login = and eventcd = 'LF' and fspro_UserId = and datediff( minute, eventtime, getdate() ) < 10 and eventtime > ( select max(eventtime) from tbl_TRK_MemberActivity with (nolock) where eventcd = 'LI' and fspro_UserId = ) update tbl_fspro_members set passwordlock = 0 where fspro_userid = update tbl_fspro_members set passwordlock = 1 where fspro_userid = select passwordlock from tbl_fspro_members with (nolock) where fspro_userid = #_jsonString#