Define daily user access to streams via Security rules

[simonvm9114]

Hi all,

I am looking for a way to determine on a daily level which users in a Qlik Sense Enterprise environment have access to which streams. This should be possible via the security rules. Currently active security rules are saved in the QSR database and updates over time in the security rules can be found in the logging files. The problem I'm running into right now is that the security rules are quite complex since they can give access to users via different user attributes like their roles, attributes from the AD and even custom properties. 

Is there anyone who has experience with extracting user access to streams via logging files or the QSR? Or is there maybe an easier way to extract this as data? In the end I'm looking for a similar table as what you see when you audit the security rules on streams via the QMC as shown in the screenshot below. It would be enough if I have data for the right to read in a stream.

Thanks in advance for any assistance 

Audit results in QMC