Altiris Patch Management, custom report: SQL Relationship between Bulletins and Targets

Hi guys,

I'm trying to make a custom report to show the compliance of the Bulletins by targets. But i couldn't find the right relationship between tables to show this information.

For example, I need to know for each bulletin, what are the targets that are assigned to each policy?

 

Here is my SQL's:

 

1) At First, i choose a specific Bulletin by Guid :

 

BulletinsGUID.txt

 

2) Then i run this SQL with the Guid that i want and pasted into the variable --> @BulletinGuid = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'

TargetsByBulletin.txt

 

3) The query will show the Bulletin Name and Target name, but i haven't  could to acquire the results that i need, can anybody help me ??

Thanking in advance