Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have the following data:
I wish to know if per DB the Match field in every Srv. e.g.
Stated another way.. the DB must have the same login across all servers (finding the server in the cluster that does not have all the logins as the other servers)
DB | SrvDb | db_owner | db_denydatawriter | db_datawriter | db_datareader | Match |
DbB | Srv1 | DbB | 1 | 1 | 0 | 1 | 1,1,0,1 |
DbB | Srv2 | DbB | 1 | 1 | 0 | 1 | 1,1,0,1 |
DbB | Srv3 | DbB | 1 | 1 | 0 | 1 | 1,1,0,1 |
DbC | Srv1 | DbC | 1 | 0 | 2 | 1 | 1,1,2,0 |
DbC | Srv2 | DbC | 1 | 0 | 1 | 1 | 1,1,1,0 |
DbC | Srv3 | DbC | 1 | 0 | 2 | 1 | 1,1,2,0 |
Solved! Go to Solution.
Thank you @PhilipTreacy for your prompt reply.
Hi @CharlotteCity12 ,
Based on the information you provided, I have created a sample data and you can follow the steps below:
1. Add a new column.
Mis =
VAR _DB = 'Table'[db_owner] & "," & 'Table'[db_denydatawriter] & "," & 'Table'[db_datawriter] & "," & 'Table'[db_datareader]
RETURN
IF ( 'Table'[Match] = _DB, "Match", "No Match" )
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @PhilipTreacy for your prompt reply.
Hi @CharlotteCity12 ,
Based on the information you provided, I have created a sample data and you can follow the steps below:
1. Add a new column.
Mis =
VAR _DB = 'Table'[db_owner] & "," & 'Table'[db_denydatawriter] & "," & 'Table'[db_datawriter] & "," & 'Table'[db_datareader]
RETURN
IF ( 'Table'[Match] = _DB, "Match", "No Match" )
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not clear what you want. What login are you referring to? I dno't see anything in your data.
Please supply a clear example of the desired result.
Phil
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |