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.
Dear All,
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,
QuietLeni
Discussion Filed Under:
Comments 2 Comments • Jump to latest comment
Dear All,
So far, I have found a view which exposes the PackageID and AdvertisementID and I am using that to get my values, but I do not know what tables I can use to connect the PackageID to the Bulletin GUID. I think that there is the ResourceAssociations table, but I have lost it from there.
Thanks in advance,
QuietLeni
I stand by the accuracy of my Inventory of the organisation. Don't blame me for the picture that it presents...
Dear All,
For anyone who is interested (which sounds like noone?)
It seems that there is an ItemReference table, similar to the ResourceAssociations table:
SELECT *
FROM ItemReference ir,
Item ip,
Item ic
WHERE HINT = 'SWUADVERT'
AND ip.Guid = ParentItemGUID
AND ic.Guid = ChildItemGUID
Well, depending upon the HINT field, we get different reference types.
I hope that this helps...
Regards,
QuitLeni
I stand by the accuracy of my Inventory of the organisation. Don't blame me for the picture that it presents...
Would you like to reply?
Login or Register to post your comment.