1 Reply Latest reply on Jul 6, 2018 10:11 AM by Jeff Strauss

    Email alert when Active directory Synchronization is failed

    Manasa Chimmani

      Hi,

       

      We have scheduled a number of active directory groups to be synchronization  every day. But as one of our AD group is removed in the domain the AD synchronization in tableau is failed. But we did not get any email notification. Could you please help me in how to set up the email notification when the Ad group synchronization is failed.

       

       

      Thanks in advance.

       

       

      Thanks,

      Manasa

        • 1. Re: Email alert when Active directory Synchronization is failed
          Jeff Strauss

          One such method for viewing failed AD syncs is to look at the built-in admin report: BackgroundTasksforNonExtracts

           

           

          But if you want to be alerted to the failure, then you can do something similar to this.  Attached is the workbook, you will have to update the connection specific to your deployment.

           

          1. Query the internal Tableau Postgres database with a readonly account.

           

          2. Use custom SQL:

          SELECT

            groups.name as name,

            _users.name as _users_name,

            _sites.name as _sites_name,

            domains.short_name AS short_name,

            _async.invalid_grp

          FROM public.group_users

            INNER JOIN public.groups  ON (group_users.group_id = groups.id)

            INNER JOIN public._users  ON (group_users.user_id = _users.id)

            INNER JOIN public._sites  ON (groups.site_id = _sites.id)

            INNER JOIN public.domains ON (groups.domain_id = domains.id)

            LEFT JOIN (select substring(notes, (position('''' in notes)+1), ((position('in Active' in notes)) - (position('''' in notes)+1))-2) invalid_grp

                      from async_jobs where notes like '%No such group%') _async ON groups.name = invalid_grp

           

          3. Create a filter on the field "invalid_grp"

           

          4. Subscribe to the view, and only send if it's not empty