Here is python script. that i used to export all our roles into a csv files as a matrix
Original Message:
Sent: 10-02-2025 00:41
From: Amit Abdul
Subject: Roles and Permission Comparisons
I would like to export all the roles, etc, so that I have a way to analyze it and ensure that we do not have something unusual. Can you please share with us how to export it using PowerBI or another tool?
------------------------------
Amit Abdul
Original Message:
Sent: 10-01-2025 11:59
From: Daniel Possekel
Subject: Roles and Permission Comparisons
Hi James, I am happy to share this. I'd like to first wait for the new permissions (new UI) to hit our org before I run another update. What exactly are you looking for? Compare orgs, roles or review licenses? These were the use cases I had so far.
------------------------------
Daniel Possekel
Business Analyst
Original Message:
Sent: 10-01-2025 09:05
From: James Terry
Subject: Roles and Permission Comparisons
@Daniel Possekel
Hello, I would like to see your approach in more detail for either Power Bi or Power Query when able.
Thanks!
------------------------------
James Terry
Contact Center Support Engineer 3
Original Message:
Sent: 08-01-2025 02:45
From: Daniel Possekel
Subject: Roles and Permission Comparisons
Hi Amit, I had the same demand and build myself a comparison in Power BI within one stage using Power Query. If you are not familiar with Power BI as such, Power Query is also part of Excel. I used it to unfold the JSON structure of the API Explorer output. Extending it to compare across two exports shouldn't be much of an extension of the logic.
If this could be an option, just let me know - I am happy to share my approach in more detail, if it helps.
------------------------------
Daniel Possekel
Business Analyst
Original Message:
Sent: 07-31-2025 08:28
From: Amit Abdul
Subject: Roles and Permission Comparisons
Hello,
how does one go about comparing the roles and permissions on different environments?
We have a development, staging and production environment and again and again we run into a problem where "admin" has different divisions and permissions assigned in the staging environment compared to the production environment. Telling people to keep it things organized does not work. I would like to have something like an easy export for all the roles and permissions for a particular user so that I could compare it. Even in Excel. Is there anything like this?
#SystemAdministration
------------------------------
Amit Abdul
------------------------------