Database

Hi, it should be possible - based on schema documentation* there are two tables that should do the job:
* WFConfigurationSecurities - this contains information about who have privileges
* AppReports - this contains list of the reports

There is a key between those tables, so you can join them on ARP_ID = CSC_ARPID.
On WFConfigurationSecurities you will find CSC_UserLoginName and CSC_UserName.

Those could be later joined with CacheOrganizationStructure to get more informations on users based on AD/AAD (join on login)

* https://developer.webcon.com/2023/resources/db/?PageSpeed=off#AppReports
* https://developer.webcon.com/2023/resources/db/?PageSpeed=off#WFConfigurationSecurities
* https://developer.webcon.com/2023/resources/db/?PageSpeed=off#CacheOrganizationStructure

Hi
is there a way to get from the database all the permissions to all the reports that we have ? I was not able to find any column with that information and I do not know how to get such info