Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to get a list of NPrinting users and their NPrinting reports

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

How to get a list of NPrinting users and their NPrinting reports

Last Update:

Jun 7, 2021 6:26:12 AM

Updated By:

Sonja_Bauernfeind

Created date:

Feb 28, 2018 1:18:43 AM

Querying the NPrinting PostgreSQL database allows to export all NPrinting users and their reports. 

 

Environment:

Qlik NPrinting 

 

These steps are to be performed locally on the machine running the NPrinting Repository service (QlikNPrintingRepoService)

If you already have a connection you can use that and skip the steps to create a new one

  1. Click Add a connection to a server
  2. Use the following details in New Server Registration
  3. Name: NPrinting
  4. Server: localhost
  5. Port: 4992
  6. Maintenance DB: postgres (select from pull down)
  7. Username: postgres
  8. Password:  The password that you entered during installation or see first step
  9. Open the Query tool (Ctrl+E) or click the icon
  10. Paste the following SQL statement in the SQL Editor
    SELECT
      * 
    FROM 
    public.publish_report_task_recipient
    join recipient on (recipient_id=recipient.id)
    join publish_report_task on (publish_report_task_id=publish_report_task.app_task_id)
    join publish_report_task_report on (app_task_id=publish_report_task_report.publish_report_task_id)
    join task on (task.id=app_task_id)
  11. Execute to file (F8 or click the button) 
  12. Change settings in Export data to file as required
  13. Click OK

    Export Data to file.png

  14. Open the Output CSV file in Excel
  15. Hide unwanted columns as required
  16. Enable Filter [on the Editing section of the ribbon: Sort & Filter > Filter]

    Sample:

    Excel Sheet filter example.png
Labels (2)
Comments
martinpohl
Partner - Master
Partner - Master

Hello Sonja,

that's fine.

Can we also see that an user has downloaded a report from NewsStand?

Regards

Martin

Contributors
Version history
Last update:
‎2021-06-07 06:26 AM
Updated by: