Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Create a report based on workflow exclusion volume (audit)

Avatar

Level 1

Hello,

I would like to create an audit report (to send via email, automated if possible) to be able to monitor exclusion volume on automated workflows. In particular, I want to be able to output the volume of individual inclusion queries, exclusion queries, intersection results/complements etc... so there is a long-term log. Is this possible?

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Thanks for sharing the details.

 

I feel there is an ambiguity in your question.

 

If you are looking only for the volume of your complement result set , then simply use alert activity after your complement to send the total count as below:

You can edit the source code to add your comments .

 

Screen Shot 2020-10-04 at 12.15.19 am.png

or 

If you want to report the actual result set then add data extract activity after complement to export the file using SFTP or an email attachment.

 

Hope this helps.

 

Thanks.

View solution in original post

0 Replies

Avatar

Community Advisor

Hi @the_eddie ,

 

Could you please explain your question clearly with a use case if possible?  

 

Thanks.

Anita

 

Avatar

Level 1

Hello,

 

I have a workflow that starts off with two forks - one for exclusions and one for inclusions.

 

Volume is dropped in a range of exclusions, and complements are generated for the dropped volume - at the moment there are End's coming off these complements, but I would like to be able to provide a single daily report/audit that collates the volume for the results of each complement. 

 

 

Capture.JPG

 

Let me know if you need any more information.

 

Avatar

Correct answer by
Community Advisor

Thanks for sharing the details.

 

I feel there is an ambiguity in your question.

 

If you are looking only for the volume of your complement result set , then simply use alert activity after your complement to send the total count as below:

You can edit the source code to add your comments .

 

Screen Shot 2020-10-04 at 12.15.19 am.png

or 

If you want to report the actual result set then add data extract activity after complement to export the file using SFTP or an email attachment.

 

Hope this helps.

 

Thanks.

Avatar

Administrator

Hi @the_eddie,

Were you able to resolve this query with the given solution? Do let us know if you need more help here.

Thanks!