K1000 Reporting - Monthly patch report
I've got this query to generate a report based on my list of approved patches "My Patch Label"
SELECT LABL.NAME as MACHINE_GROUP,
L.NAME as PATCH_GROUP,
MACH.NAME as MACHINE,
PP.TITLE AS PATCH_TITLE,
WHEN 'PATCHED' THEN 'Patched'
WHEN 'NOTPATCHED' THEN 'NOT Patched'
END as PATCH_STATUS,
PLMS.STATUS_DT as STATUS_AS_OF,
PLMS.DEPLOY_STATUS_DT as DEPLOYED_AS_OF
FROM ORG2.PATCHLINK_PATCH_LABEL_JT PPLJT
on L.ID = PPLJT.LABEL_ID
on PP.UID = PPLJT.PATCHUID
ON PP.UID = PLMS.PATCHUID
ON MACH.ID = PLMS.MACHINE_ID
ON MACH.ID = MLJT.MACHINE_ID
ON MLJT.LABEL_ID = LABL.ID
WHERE L.NAME IN ('My Patch Lablel')
order by LABL.NAME,
but as we continue to use KACE for patch deployment the size of the reports continues to grow. Does anyone know how can I introduce a filter by date so the same report is generated but only of the activities done through a specific month?