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

[Sonja_Bauernfeind]

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)

• Keep the PostgreSQL database password handy. If you have forgotten it see:   How to recover or update the NPrinting repository database super user password
• Optional but recommended: Take a backup of the database: Backup and restore Qlik NPrinting
• For instructions on how to work with PostgreSQL: Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti... 

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
    
    
    
    
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:
    
    

[martinpohl]

Hello Sonja,

that's fine.

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

Regards

Martin