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?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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.
Answered 04/13/2011 by: dchristian
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity