How to send automated email alerts on expiry date from confluence.

Question

We keep our software license information on a page in confluence.

we have a table setup with all the different companies, software, and expiration dates among other information.

I would like to automatically be notified via customized email about 30 days before the expiration dates of the different software. How can this be done?

We are using enterprise version and does not have authority to ask for any paid license. So any other free solution like scrip/markup/coding or any other free way like we have for JIRA automation...

Trigger, condition, action.

Kusumitha Korrapati · Answer

Hi @Yatiraj Sharma

I am looking for something similar that you were trying to achieve, were you able to create an email alert.

looking for a possible solution without the apps.

thanks in advance !!

Aron Gombas _Midori_ · Answer

Expiration tracking and email alerts are core features in the Better Content Archiving app.

Note that the app tracks the expiration of pages, not rows in a table. So it would require you to create a page for each software license, then set the expiration date on the page. (The expiration date can be 30 days earlier than the license period end date, of course).

Then it would turn the page which represents the license to "expired" status, and email your selected recipients.

You could also:

* Group the licenses that expire the same day (these are always existing) to the same page. Or group them to the same parent page, add the expiration date to the parent and make inherited.
* Set the content owner of the page to the person who is responsible for the software license. And then set up the notification emails to be sent for the content owner. This way you won't email those peope who can't take care of the renewal.

(Discl. it is a supported and paid app developed by our team.)

Alex Koxaras -Relational- · Answer

@Yatiraj Sharma

I don't think that such an app can exist, currently, for confluence. I mean what you are saying is that this software should send a notification to someone using a date, for which there isn't a standard field to be taken into account. How will the software understand which column have the specific dates? And what about if by mistake a user deletes one date?

You can do what you are asking on Jira, but not on confluence.