How to retrieve recipient names from each source document
Article Number: 000005602 | Last Modified: 2018/06/12
For each Publisher task there is a log entry stored under directory DistributionService. Default location is:
Under this directory you should see a file (recreated with each run of the task) called DistributionReport.xml. There will be one DistributionReport.xml file generated for each task. In this xml file, you will see a section called RecipientList which contains the recipient information. In this example below, "domain" would appear as whatever domain your server is in and the "userid" would be the actual id of the user:
<Recipient ValidateMailAddress="false" ObjectType="Named" ID="domain\userid" IsSuperVisorAccount="false"/>
... more recipients could appear here ...
An example DistributionReport.xml file is attached to this article for reference. It reflects QlikView release v11.2 SR9.
One approach to gathering this information is to develop a QlikView application that loops through the various task sub-directories under the Distribution Service log folder and parse those DistributionReport.xml files into the app and parsing out the Recipient List data. From there you could export the data to Excel, generate a report, or store into a QVD for further processing by other QlikView applications. Just keep in mind that this xml file gets recreated with each run of the task.
Note that there was a defect in earlier releases of versions 11 & 11.2 where this distribution xml file was not being generated properly. That defect was corrected in release 11.2 SR3.
AttachmentsExample DistributionReport.xml file.xml