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 advanceSolved1.8KViews0likes1Comment
Mobile MGMT not connect to SMM with HTTP error: 500.
Hello. Im implementation SMM 7.2 in a test environment. I use implementation documentation. I use HTTP and anonymous authentication. When i connect from Mobile MGMT to the server SMM i receive message: Login Failed. HTTP error: 500. An error occurred on the server. In logs i not found any error. Do you can help?Solved738Views1like1Comment
