NPrinting Audit Logs

[weijietc]

Hi All,

Is there anyway to capture NPrinting Audit Logs as details as possible? 

Audit Logs require what the users clicks or change in :

1. User login into NP Web Console

2. User login to newsstand

3. NPrinting Designer

Thanks.

[Ruggero_Piccoli]

Hi,

All available Qlik NPrinting logs are described here: http://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/AdministeringQVNprinting/Logging.htm. There are no more log that the ones you can have by enabling the debug level. 

At the moment, June 2019, there is not a specific feature to monitor users activities.

Best Regards,

Ruggero

[Andrew_Kruger]

Please check out the Qlik NPrinting November 2020 release which contains an Audit Log capability that may help you.  https://help.qlik.com/en-US/nprinting/November2020/Content/NPrinting/AdministeringQVNprinting/Audit-... 

[Danijel]

@Andrew_Kruger 

Is it possible to load the logs directly into Qlik Sense (e.g. via the REST connector) or do the logs always have to be downloaded first?

[Ruggero_Piccoli]

Hi,

You can upload the CSV in Qlik Sense via REST connector.

Best Regards,

Ruggero

[Danijel]

Hi @Ruggero_Piccoli 

does this mean that I always have to download the file manually before reading it back into Qlik Sense?

I would like a solution without this intermediate step. Meaning a direct connection from Qlik Sense to the audit trail of NPrinting.

That way I would have less effort and less sources of errors.

Greetings

[Lech_Miszkiewicz]

Hi Danijel,

The unsupported method I am using is:

• create PostgreSQL connection from QlikSense or QlikView using following setup:
  • host: your NPrinting server - for it to work you will need to change config files of postgres to allow for postgres to listen not only on "localhost", I explained all this here: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-connect-to-postgresql-database-from-...
  • port: 4992
  • user: postgres
  • database : nprinting_audit
  • password: your repository password

Once you create this you can SQL select the only table available there which contains audit logs. The way I work with it is that I run extract daily when no one is using it I store it to QVD file and each day i run incremental load to append  data to it. This allows me to store historical audit too. Everything else in logs is self explanatory.

Things to remember:

• timestamp is in UTC mode so you may need to convert it to your local time with Qlik function

NOTE: THIS IS NOT SUPPORTED METHOD SO YOU WILL BE DOING IT AT YOUR OWN RISK

on the other hand it works like a charm 🙂

[Ruggero_Piccoli]

Hi,

You can connect to the Repository as suggested by @Lech_Miszkiewicz or, starting from next version February 2021, you can connect via API that is supported:

Audit data can be exported as JSON via API
Audit data can now be exported in JSON format due to new API audit/events.

Best Regards,

Ruggero

[Danijel]

Hi @Ruggero_Piccoli 

thanks for the info.

The version is not yet published 🙂

Regarding the suggestion of @Lech_Miszkiewicz  . He writes that this is not supported, does that mean that in case of technical problems Qlik denies support?

As I understand it, the connection would be read-only?

Greetings

[Ruggero_Piccoli]

Hi,

Yes, sorry, February 2021 is not yet published but it will be soon so I think you could evaluate to wait some days and implement an API based solution when available or follow the suggestion from @Lech_Miszkiewicz.

February 2021 is available as technical preview at https://community.qlik.com/t5/Technical-Preview-Discussions/Qlik-NPrinting-February-2021-Technical-P... in case you want to test it in a sandbox (not in production). 

I told this to you so you can make a better decision. I want to avoid that you invest time today to develop the SQL solution and after few days the API become available. 

I hope this helps.

Best Regards,

Ruggero