Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

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
QuietLeni's picture
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

Comments 2 CommentsJump to latest comment

QuietLeni's picture

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

What is the point of an Asset Management Solution that needs excessive management? Let me help you.

QuietLeni's picture

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

What is the point of an Asset Management Solution that needs excessive management? Let me help you.

SOLUTION