Need to generate an email report of App Refreshes and latest data in each application

[mshoffman]

I have recently migrated from Qliksense Enterprise to Cloud.  In Enterprise we had an email report that detailed for each application when it refreshed that day.  Also for each app it showed one or more data elements managed in the app along with the latest date for that particular entity.  So something like 

App Name.   Data Entitiy. Latest Data Date.  Application Refresh Date/Time

This was done with NPrinting and emailed to various stakeholders.  

I am looking for some help as to a best overall approach to implement this.  There are a lot of options mentioned (Automation, Reporting etc) and I want to make sure I head down the right direction.

[rafaelencinas]

Hi @mshoffman !

You can install Monitoring Apps ,

https://community.qlik.com/t5/Official-Support-Articles/The-Qlik-Sense-Monitoring-Applications-for-C...

After that, you can save or read a binary load from Apps Reloads Analyzer and send your customized report to users ( with Report Service ).

Bye!

[vkramBI4Qlik]

I just did this activity recently. Use the below "Reload Analyzer" monitoring app.

https://github.com/qlik-oss/qlik-cloud-reload-analyzer

Follow the instructions from the PDF file included in the GIT folder ( https://github.com/qlik-oss/qlik-cloud-monitoring-apps/tree/main/docs ) to install it

Create a new sheet with Table Chart with the fields that you need. With an additional dummy expression with Set Analysis filtering today's date.

Now , There are 3 options. The details of all these are available in Qlik Community Posts (You will find on Googling). 

1. Schedule app by right clicking and Create an alert on the chart to send alert when the data changes (date field kind of).

2. Use reporting to create a Excel sheet at a specific time of the day using a template.

3. Automations to read the Table chart and send email as per the daily schedule.

Hope this helps , Good Luck !

Thanks

Vikram