Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm currently on the final stage of the implementation of a model and we have been requested to provide a report that contains at least the following items:
- User that performs the action that grants/revokes licences (User and/or Document)
- Final user (user that had his/her licence granted or revoked)
- Date in which the grant or revoke of licence was performed.
- Modified parameter (which one is the parameter that changes to indicate that a granting or revoking of a licence has been performed)
- Old value and new value of the licence (which kind of licence the user had and which kind of licence the user has now)
I would like to know if the Qlikview Server platform can provide this information and in the case it does how can we obtain it or read it.
On the test server the auditlog was activated, but i couldn't find in a precise way to know if the actions (grant/revoke) regarding the licences are been recorded.
Could please anyone help me in letting me know if the report that is being requested is viable or if Qlikview Server is not able to provide this information?
The QlikView Server Service can be made to log these actions to the Events log(s). These logs can be found in C:\ProgramData\QlikTech\QlikViewServer.
To enable Audit Logging, open QMC and navigate to System->Setup->QlikView Servers->Your server->Logging->Logging and mark the "Enable Audit Logging" checkbox.
Examples of what the Events log will show you whenever CALs are revoked/assigned:
:
2016-01-16 13:42:08 2016-02-12 16:38:03 4 100 Notice CAL allocation: Named CAL (not used for 24 hours) "COMPANY\USER1" deleted - ok.
2016-01-16 13:42:08 2016-02-12 16:38:03 4 100 Notice CAL allocation audit: "COMPANY\USER1" deleted by "COMPANY\ME"
2016-01-16 13:42:08 2016-02-12 16:38:16 2 500 Warning SE_LOG: User - GetGroups: DCName is empty. Fetching...
2016-01-16 13:42:08 2016-02-12 16:38:47 4 100 Notice CAL allocation: Named CAL "COMPANY\USER2" added - ok.
2016-01-16 13:42:08 2016-02-12 16:38:47 4 100 Notice CAL allocation audit: "COMPANY\USER2" added by "COMPANY\ME"
:
You can easily create a QVW document that parses and displays these events using standard QlikView techniques.
Best,
Peter
The QlikView Server Service can be made to log these actions to the Events log(s). These logs can be found in C:\ProgramData\QlikTech\QlikViewServer.
To enable Audit Logging, open QMC and navigate to System->Setup->QlikView Servers->Your server->Logging->Logging and mark the "Enable Audit Logging" checkbox.
Examples of what the Events log will show you whenever CALs are revoked/assigned:
:
2016-01-16 13:42:08 2016-02-12 16:38:03 4 100 Notice CAL allocation: Named CAL (not used for 24 hours) "COMPANY\USER1" deleted - ok.
2016-01-16 13:42:08 2016-02-12 16:38:03 4 100 Notice CAL allocation audit: "COMPANY\USER1" deleted by "COMPANY\ME"
2016-01-16 13:42:08 2016-02-12 16:38:16 2 500 Warning SE_LOG: User - GetGroups: DCName is empty. Fetching...
2016-01-16 13:42:08 2016-02-12 16:38:47 4 100 Notice CAL allocation: Named CAL "COMPANY\USER2" added - ok.
2016-01-16 13:42:08 2016-02-12 16:38:47 4 100 Notice CAL allocation audit: "COMPANY\USER2" added by "COMPANY\ME"
:
You can easily create a QVW document that parses and displays these events using standard QlikView techniques.
Best,
Peter
Thank you so much for the answer. It was useful and it worked