NIM

Create a table notification task

For more information, see Table notification tasks.

  1. Create a filter or Create an auditing query that outputs the data whose rows you want to individually send by email.

    For this example, we'll use a simple filter named azure_users that outputs all users in our HR source system who have accounts in our Azure AD target system. The columns in this filter are the columns that will be available to insert into the notification template. Note that the filter must include a column with the users' email addresses.

    2022-01-11_14-18-10.png
  2. Go to Scheduler > Overview.

  3. Click Add.

  4. Select table-notification for the Type.

  5. Enter a Name.

    For example, azure_user_details.

    2022-01-11_14-35-24.png
  6. Click Save.

  7. For the Table, select the filter or auditing query that you created in step (1).

    For this example, filter.azure_users.

    2022-01-11_14-26-15.png
  8. Click Save.

  9. Create a notification template.

    For this example, we'll create one named azure_user_details_template.

  10. For the Notification Event, we'll select the azure_user_details table notification scheduled task created in step (3).

    2022-01-11_14-36-40.png
  11. For the To field, click Insert Variable.

    1. For this example, we'll select the mail column of the filter (the variable data.mail).

      2022-01-11_14-38-15.png
    2. Click Insert.

  12. Enter a Subject.

  13. Compose the body of the notification template.

    For example:

    2022-01-11_15-10-45.png
  14. Click Save.

  15. Go to Scheduler > Overview.

  16. Edit a task for the azure_user_details table notification scheduled task created in step (3).

  17. Recommended: To test this configuration, configure your Mail settings to use a Papercut SMTP test environment. Then perform a Manual run for the azure_user_details table notification scheduled task created in step (3).

    2022-01-11_15-13-17.png
    1. One test email is sent per row in the filter's output.

      For example:

      2022-01-11_15-15-30.png
  18. Go to the Schedule tab to set up a Scheduled run, then click Save. Or, perform a Manual run.