Linux web server and statistics collection. What do you advise?

Question

linux

Hello everyone, I'm interested in solving the problem:
1) There is a Linux server.
2) There is a collection of statistical reports on a weekly basis. (average 250 hosts)

It is necessary to implement:
1) Authorized access to the resource.
2) The ability to create layouts for filling out reports (as a rule, this is something like an Excel spreadsheet with fixed fields)
3) It is desirable that you can summarize the result of collecting data from all hosts.

I understand that with such a task you need to write a unique product, but maybe someone knows quick solutions. Type cms with modules. Or ready-made server solutions for collecting statistical reports.
ps option in which it will be a separate software, and not a web application is also considered.

Answer 1

Most likely there is no complete option out of the box for you. For reporting, you can use eclipse birt or jasperpeports.
In the case of Birt - https://www.eclipse.org/birt/ it has a server version, I worked with it for a very long time. You create a report file, upload it to the server, and when requested, a report is generated from a database or other source. Yes, there is a plug-in for eclipse (development environment) for creating report-files, almost like excel.
C jasperReports https://community.jaspersoft.com/project/jasperrep... is about the same.

Answer 2

It is not clear what a "host" is and how something can be collected from it. Host is a technical term. Not business and probably in the topic meant something else. Maybe these hosts have ftp/cifs file storages?