Qlik Application Automation : Alert app owners and TenantAdmins about orphaned data connections

[Madhushree_BP]

This article contains additional information on the  "Alerts app owners about orphaned data connections" template. You can find this template in the template picker when creating new automation.

Note: This is only for Qlik Sense applications.

This template sends an email to each owner of a data connection that has been orphaned by its associated space being deleted, or emails each TenantAdmin data connection that has been orphaned by deletion of their respective owners.

Suppose a user has connected to a data connection in the space "XYZ" and then the "XYZ" space was subsequently deleted. This template can be used to send an email to the owners of the data connection. Then the owners can decide whether to move these connections to new spaces so they can continue to be used or to delete them.

Steps to set up the values in the template:

1. Set the value for the variable EmailTenantAdmins which sends an email to all the tenant admins regarding the list of data connections that are orphaned. The value can be YES/NO.

Automation structure

1. Retrieves all the users and the data connections that the users are connected to in the tenant.
2. Retrieves the space id.
3. Loop over data connections and check if the user list is not empty and verify whether the connection belongs to a deleted user and also verify whether the space is deleted.
4. If connections are found, gather all the required information to send an email:
   • Retrieve tenant information using the Get Current Tenant Info block.
   • Loop over the list of data connections and check the users with the tenantAdmin role and picks the username and useremail of the tenant admin and loop over the "TenantAdminList" and retrieve all the email addresses of the tenant Admins.
5. Construct the email body using the above information and sends out an email to the owners of the data connection.

Below is the image of the email received.