Install Date of Individual Patch
I'm looking for a report or to create a report showing what patches have been installed on a machine (kb number and possibly a description of the patch), when the patch was installed, and who installed the patch. The date installed and by who are the two critical pieces we need to satisfy our security audit. Can any one provide the table(s) that would contain this information?
I found a tool, wmic, which we ran by the following command line against a machine
wmic /node:'<machinename>' qfe GET description,FixComments,hotfixid,installedby,installedon,servicepackineffect > QFE-<machinename>.txt
It pulls the required information. I would like to duplicate this information in Altiris. I found the Inv_AeX_OS_Updates_spt table, but when ran against the same machine, the Inv_AeX_OS_Updates_spt does not report any installed dates or installed by.
Comments
Hello mfox,
This is gathered by inventory solution, not patch, and is in the AeX_OS_Quick_Fix_Engineering dataclass. What exactly are you looking the report to do? All installed fixes? Dropdown to select a fix?
Cheers,
Jim
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
Thanks for the quick response.
Our sas70 audit comes to us with 20-30 servers that they need to see what patches have been applied to the machine, when they were applied and who applied them.
mfox
this worked great. thanks.
select
Inv_AeX_OS_Quick_Fix_Engineering.[CS Name] as [Name],
Inv_AeX_OS_Quick_Fix_Engineering.[Hotfix ID],
Inv_AeX_OS_Quick_Fix_Engineering.Description,
Inv_AeX_OS_Quick_Fix_Engineering.[Fix Comments],
Inv_AeX_OS_Quick_Fix_Engineering.[Installed By],
Inv_AeX_OS_Quick_Fix_Engineering.[Installed On],
Inv_AeX_OS_Quick_Fix_Engineering.[Service Pack In Effect]
from Inv_AeX_OS_Quick_Fix_Engineering
where [cs name] = 'machinename'
mfox
Would you like to reply?
Login or Register to post your comment.