[SQL] Machine Patch Status for Patches in a Label
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
Answers (2)
Please log in to answer
Posted by:
knowmad
14 years ago
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?
Where do I find the number for the LABEL_ID for changing the IN section and are the number that are already there important?
Posted by:
RichB
14 years ago
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
