How to query the database for additional details of a Campaign run.

Document ID : KB000124820
Last Modified Date : 22/01/2019
Show Technical Document Details
Question:
Is it possible to get additional details from a campaign out of the database such as the specific resources updated, and the users that were effected so we can occasionally audit campaigns to ensure they updated everyone correctly?
 
Answer:
Campaign details are stored in the BusinessFlowEntities and can be queried for various details as follows:
Please find the queries, replace "?" with BusinessFlowId.


List of Users involved in the Campaign:
select * from BusinessFlowEntities where BusinessFlowId = ? and EntityType = 1
 
List of Resources involved in the Campaign:
select * from BusinessFlowEntities where BusinessFlowId = ? and EntityType = 2

List of Roles involved in the Campaign:
select * from BusinessFlowEntities where BusinessFlowId = ? and EntityType = 3