1 Reply Latest reply on Nov 6, 2015 10:18 AM by Santosh Adari

    Is there a way to  get info on who has access to dashboards and level of access for all dashboards in one go ?

    Swati Rout

      Is there a way to  get info on who has access to dashboards and level of access for all dashboards in one go

        • 1. Re: Is there a way to  get info on who has access to dashboards and level of access for all dashboards in one go ?
          Santosh Adari

          You should be able to pull from postgres DB, here is a sample sql, you can add other tables to get the details you need.

           

          SELECT "_users"."id" AS "id",

            "_users"."name" AS "name",

            "_users"."login_at" AS "login_at",

            "_users"."friendly_name" AS "friendly_name",

            "_users"."licensing_role_id" AS "licensing_role_id",

            "_users"."licensing_role_name" AS "licensing_role_name",

            "_users"."domain_id" AS "domain_id",

            "_users"."system_user_id" AS "system_user_id",

            "_users"."domain_name" AS "domain_name",

            "_users"."domain_short_name" AS "domain_short_name",

            "_users"."site_id" AS "site_id",

            "_sites"."id" AS "id (_sites)",

            "_sites"."name" AS "name (_sites)",

            "_sites"."url_namespace" AS "url_namespace",

            "_sites"."status" AS "status"

          FROM "public"."_users" "_users"

            LEFT JOIN "public"."_sites" "_sites" ON ("_users"."site_id" = "_sites"."id")