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
If you are using consistent user names across all three servers you could try establishing a connection to each _users view and then blending on Name to find out which exist on one, two, or all of the servers.
You should probably avoid using the id fields as they are likely different in each deployment.