Is there any way to export a dataset with the all the projects and their client required roles, similar with the page “configure > security > user,roles”, instead of opening each project and checking in the properties one by one?
If it's an internal usersource, you could use a tool like GitHub - inductiveautomation/kindling to read the sqlite file and then find the table that stores the roles.
Update: Linked the wrong tool initially ![]()
There's nothing built in that can do this easily. Kindling won't help in this particular case because this is data stored in the project - while projects are technically in the idb in 7.9, in both 7.9 and 8.x the 'global props' resource that holds this information is gzipped Java serialized data. Not particularly human friendly to work with.
In theory, you could write a gateway script that works through all the projects and exports this information. In practice, writing that script would probably take longer than just clicking through all the projects manually.
Understood. Probably will be quicker to make this manually, I’m building an access matrix and after that I’ll just need to update the matrix for any change or new project. Thank you!