If I'm understanding your requirement correctly, SAS/CONNECT will provide the functionality needed to automate this reporting. If CONNECT is available on all SAS installations (it is included with Viya) then you can build a SAS application that will connect to each SAS installation and download the required reporting data automatically. You could also schedule this application so no human intervention is required.
... View more
