Can we send password expiry email notification without an attachment

[Yaswanth]

Hello Team,

We have configured the password expiry notification for AD accounts, the notification email is getting triggered with an attachment. but the client expectation is the attachment is not required in the email.

We have tried to disable "Send email as attachment" checkbox in the analytics but the email template is also disabled along with that..

Can you let us know how to send a notification without an attachment.

Thanks.

[adarshk]

Hi @Yaswanth 

Password expire emails are triggered through analytics and for analytics, its by default the excel will be attached when an email is sent.

[rushikeshvartak]

Share below

• Can you share report configuration
• Group by username under global configuration
• Email Template details

[Yaswanth]

Hello Rushikesh Vartak,

• Can you share report configuration
• select u.username,u.firstname, u.lastname, e.endpointname as 'Application', ac.name as 'Account Name', date_add(ac.LASTPASSWORDCHANGE,Interval 30 day) as 'Password Expiration Date' from users u, accounts ac, user_accounts ua, securitysystems ss, endpoints e, policyrule p where ac.status in ("Manually Provisioned",1,'Active') and (ac.ACCOUNTTYPE is null or e.ACCOUNTTYPEFORSERVICEACCOUNT not like concat('%',ac.ACCOUNTTYPE,'%')) and ac.LASTPASSWORDCHANGE is not null and u.USERKEY=ua.USERKEY and u.STATUSKEY=1 and ac.ACCOUNTKEY=ua.ACCOUNTKEY and ac.ENDPOINTKEY = e.ENDPOINTKEY and e.SECURITYSYSTEMKEY = ss.SYSTEMKEY and ss.POLICYRULE=p.POLICYRULEKEY and ss.POLICYRULE not in ('') and ss.POLICYRULE is not null and ss.STATUS=1 and e.status=1 and DATEDIFF(date_add(ac.LASTPASSWORDCHANGE,Interval 30 day),sysdate())=2 and e.endpointname = 'XXXXXXX';

• Group by username under global configuration --- Unchecked

• Email Template details --

<span style="font-size:10.5pt;color:black">Dear <b>${ANALYTICSDATA.firstname[0]} ${ANALYTICSDATA.lastname[0]}</b>, <o:p></o:p></span></p><p style="margin-left:30.0pt;background:white;vertical-align:middle">

[rushikeshvartak]

Group by username under global configuration --> Check this option

[Yaswanth]

Sure, And can you help us with the password expiry notification without attachment?

[Yaswanth]

Can you help me with Analytics query and email template to achieve email notification without attachment

[rushikeshvartak]

Above will make sure it sent without attachment.

We are using analytics with above config which does not sends emails

also save data in analytics make difference 

It should be

[Yaswanth]

Sorry.. you mean to say, without attachment we cant send eamils?

[rushikeshvartak]

We can send without attachment

[Yaswanth]

Can you share me the analytics and template here? since we have tried all the ways by enabling the Group emails by username in global configurations.. so it is sending attachments

[rushikeshvartak]

Email 

[Ivan5533]

Hi @rushikeshvartak ,

I have a similar use case where the manager is to be notified that the user's enddate is coming up. I have applied your settings but the attachment is still being sent with the email.

To: has my email

@Yaswanth Have you found a solution for this? If so, I would appreciate if you could share it with me.

Kind regards,

Ivan

[sk]

Saviynt by default sends attachment if notification is sent from analytics. There is no option to skip it. If required you may need to open a IDEA for the same.

[rushikeshvartak]

Untick save data it will not send attachement

[Ivan5533]

Hi @rushikeshvartak, @sk,

You are both telling me different things, Is it possible or not to send an email with analytics without the attachment?

After trying @rushikeshvartak  suggestion about untick the save data, the attachment is still being sent.

Kind regards,

Ivan

[rushikeshvartak]

Please confirm report type runtime or normal

[Ivan5533]

@rushikeshvartak Normal

[rushikeshvartak]

Screenshot 

[Ivan5533]

@rushikeshvartak 

Kind regards,

Ivan

[rushikeshvartak]

Please recreate email and validate . This is working for us

[Ivan5533]

Hi @rushikeshvartak 

We are on version 23.11, can you verify that we are on the same version? Below is a screenshot of the email template so you can validate that it is correct.

Kind regards,

Ivan

[rushikeshvartak]

There is no relation of version its working for us from v23.6 till 24.4

[rushikeshvartak]

Follow below Steps

1. Create Email Template
   1. Create new analytics using SQL Query  - select 'admin' as username, 'Rushi Data' as data from dual
2. Run Report
3. Check Email

[Ivan5533]

Hi @rushikeshvartak ,

Same configuration, different results

Email template:

Analytics:

Email:

Kind regards,

Ivan

[rushikeshvartak]

Make Alias capital 

select 'admin' as USERNAME, 'Rushi Data' as data from dual

[Ivan5533]

Hi @rushikeshvartak, same result

Kind regards,

Ivan

[rushikeshvartak]

Please share config screenshot

select * from analyticsconfiges where ANALYTICSNAME like '%Rushi%'

select * from ecmemailtemplate where name like '%Rushi%'

[sk]

@Ivan5533 : As per document and my personal experience it is not possible to send analytics email notifications without attachment at least till v23.10. I am not sure if the product is behaving differently in latest version or if there are any workarounds. At least in document they didn't mention anything that is changed in latest version.