Welcome to Microsoft Q&A! Thanks for posting the question.
I see that you are trying to get/store Azure Advisor recommendation for resources for the last 1 year. This is not readily available in Azure as an out of the box solution.
However, following are some of the solutions that you may explore to achieve it:
1. Configure periodic summary for recommendations - Advisor recommendation digests provide an easy and proactive way to stay on top of your active recommendations, across different categories. The feature provides the ability to configure periodic notifications for the summary of all your active recommendations, across different categories. You can choose your desired channel for notifications like email, sms or others, using action groups.
2. Alternatively, you may also use Azure Advisor APIs to get these details in your own custom solution, Azure Automation runbook, Azure Logic Apps etc. This solution could periodically get the recommendations using API --> Store it for long term review, probably in Azure Storage. This can be reviewed later based on your requirement.
Also, please note that the recommendations are based on the deployed resources and the best practices as designed at the time of Advisor rule run (which keeps evolving).
Please let me know if you have any questions.
---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.