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

[Elvizen]

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

[Elvizen · Accepted solution]

Well,

I have acquired this report, but now i need to obtain the % compliance by each target, any suggestion ??

Thanking in advance