1 Reply Latest reply on Dec 5, 2014 1:43 PM by Dan Huff

    Counting all users across all environments from different server machines.

    Sunil Tikar

      Hi All:

       

      I have three environment Test,Qa and production .I have few common users among three or two environments and few just belongs to any one of them.

      All these environments setup made on window server machines separately. So to connect postgreSQl to access tableau meta data on those machines I have to log in to 3 servers each per environment from tableau desktop.

      My requirement is to list down all the users across all three environments.

       

      lets say in test I have user id :- 1,2,3 in server name tab505(test)

      In Qa I have user id :- 1,3,5 and server name tab605(Qa)

      In prod I have user id :- 1,4,5,6 and server name tab705 (Prod)

      so my result would be 1,2,3,4,5,6

      I can connect to all three but don't know how to union _users information

       

      Please assist.

      Tableau Community ForumsTableau Administrator Toby ErksonTableau Postgre database