Hi There,
We are always there to provide custom solutions when it is about automation. While reading your requirements, we could easily recollect few of the scripts made for other clients which were associated with positive feedback,
We can help you with a powercli script which will run as a batch script, fetch the required details, store it at a common place and sends you an email with attached reports as well (if required). You can schedule it with your comfort. We will provide you a blueprint with this solution so that you can modify / add new parameters to the script after understanding it to the core.
We satisfy work satisfaction, If you would like to give us a deal, lets discuss it further and we will be on it soon.
Regards,
Ashish Arora
Triple A Consultant