How to automatically update month and year when a report is run depending on what month and year it is.
I am making a report which will be run monthly. It is to show Security Only patches for that month and year.
I want the month and year to be automatically updated when I run the report (depending on what current month and year it is).
on PATCH_STATUS.PATCH_ID = KBSYS.PATCH.ID
(KBSYS.PATCH.TITLE like '%2020-06 Security Only %')
KBSYS.PATCH.TITLE like '%2020-06 Security Monthly %'
Here, there is "2020-06 Security Only". I want the report to automatically update the "2020-06 Security Only" to the month and year the report is being run. For example: I decide to run the report in August 2020 then it should be updated to "2020-08 Security Only"
I am trying something like - KBSYS.PATCH.TITLE like '%(CONCAT(SELECT YEAR(CURDATE()),'-',SELECT MONTH(NOW()),' ','Security',' ','Only'))%' This is not working. Seems like KACE does not allow to declare variables.