A SQL Link between the Software Update Task and Succes/Failure/Error Code/Reboot Needed
Created: 25 May 2010 | Updated: 05 Jul 2010 | 2 comments
This issue has been solved. See solution.
I am making a report that returns the Bulletin, Software Update Task and the results of the task execution, i.e. the success, failure, error code and whether the machine needs a reboot.
I am basing the report upon the Microsoft Compliance and Vulnerability by Update report and I have found the link between the Bulletin and the Software Update Task. I have found that the Success, Failure, Error Code and Needing a Reboot is attached to an AdvertisementID, however, I have not been able to find a link between the Software Update Task and the AdvertisementID.
Does anyone know how I can get a link between these two objects, so that I can complete the report?
Thanks in advance,