/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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