query for all assignments made by an initiative

Summary:

We are hoping to build a report that will let us determine all assignments made in an initiative. I am not sure where to start.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):