Patch report needed
Good Day,
I need a report that gives me the following: System Name, IP, OS, Service Pack, Bios Serial number and then whether the following two patches are installed "KB2479628" and "KB2485376"
I am okay with the first part of the report but don't know how to add the two patches:
SELECT MACHINE.NAME AS SYSTEM_NAME, IP, OS_NAME, SERVICE_PACK, BIOS_SERIAL_NUMBER FROM MACHINE ORDER BY MACHINE.NAME asc
Can anyone assist me to look whether the two patches are installed?
I need a report that gives me the following: System Name, IP, OS, Service Pack, Bios Serial number and then whether the following two patches are installed "KB2479628" and "KB2485376"
I am okay with the first part of the report but don't know how to add the two patches:
SELECT MACHINE.NAME AS SYSTEM_NAME, IP, OS_NAME, SERVICE_PACK, BIOS_SERIAL_NUMBER FROM MACHINE ORDER BY MACHINE.NAME asc
Can anyone assist me to look whether the two patches are installed?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
dchristian
13 years ago
Hey anthonyw,
They key to this report is the PATCHLINK_MACHINE_STATUS table.
You need to join this to machine on machine id, and KBSYS.PATCHLINK_PATCH (for the patch info).
Post your results, if you get stuck we'll help.
They key to this report is the PATCHLINK_MACHINE_STATUS table.
You need to join this to machine on machine id, and KBSYS.PATCHLINK_PATCH (for the patch info).
Post your results, if you get stuck we'll help.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
