How can we getting monthly patching report from System Manager

I know this is an old question, but AWS has recently published a blog that demonstrates how to automate Systems Manager patching reports. The solution automatically generates reports on a scheduled basis and can deliver them via both email and CSV format, making it easy to identify unpatched machines. You can find all the implementation details here: https://aws.amazon.com/blogs/mt/automate-systems-manager-patching-reports-via-email-and-slack-notifications-in-an-aws-organization/

Hey Sujith, you can generate patch compliance reports in Patch Manager using the AWS Management Console. You can also specify a schedule for the report to be automatically generated on a periodic basis. The patch compliance report is generated as a CSV file which is stored to S3. For more details on these reports, see this User Guide topic:

https://docs.aws.amazon.com/systems-manager/latest/userguide/patch-compliance-reports-to-s3.html