This report will list machine patch status for all patches that are in a label. Modify the report to include your patch label ID's in the "in" clause.


Select DISTINCT MACHINE.NAME as 'Machine Name',
P.TITLE AS 'Patch Name', P.IDENTIFIER as 'KB Article', P.IMPACTID as 'Impact', if(P.IS_APP='0' ,'OS' ,'Application') as 'Patch Type', S.STATUS_DT as 'Detect Date',
S.DEPLOY_STATUS_DT as 'Deploy Date', S.DEPLOY_STATUS as 'Deployed'
from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P join PATCHLINK_PATCH_LABEL_JT PLJT on P.UID=PLJT.PATCHUID
where
MACHINE.ID = S.MACHINE_ID and
S.PATCHUID = P.UID
and PLJT.LABEL_ID in ('747', '779', '772', '103', '732', '120', '71')
order by 'Patch Name' asc, 'Detect Date' desc
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
based on what I learned long ago, better to ask the dumb question than to try and work in ignorance.
Where do I find the number for the LABEL_ID for changing the IN section and are the number that are already there important?
Answered 04/12/2010 by: knowmad
Senior Yellow Belt

Please log in to comment
0
A simple method for seeing the label ID number is to log into the adminui interface instead of just admin. In other words we use http://kbox/adminui instead of http://kbox/admin. This gives you more complete URLs in the address bar. Navigate to Inventory and then Labels. Select any label to see the ID number at the end of the URL. For example, here's the URL for Label ID 41: http://<yourkboxname>/adminui/label.php?ID=41
Answered 04/16/2010 by: RichB
Fourth Degree Green Belt

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