Instead of rolling your own solution,
I’d recommend you look for a guide that fits what you want to do.
As I said earlier, although it’s probably possible to integrate the aggregation of syslogs in your network into your machine’s own main syslog, I don’t think most people would think it’d be a good idea. Depending on the level of logging and other machines, that’s a lot of log data.
Also, you’d be strongly advised to inspect the log format of each machine.
Although they could use the same format, there’s no guarantee of doing so.
So, if you’re talking about raw syslog files, it’s certainly possible to rsync those files to a common location and then use whatever tool that can read those logs to query and analyze, and then now you’re really getting into what separates worthless (and antquated) tools vs what is now possible with today’s technologies.
So, for example one of the first uses of a technology I now use is Elasticsearch, which is a Hadoop-style Big Data analytical technology (Yes, it’s all free and open source). All hadoop type solutions are no-sql, and are infinitely expandable across clusters of machines so you never have to worry about storage limits. Because it’s not a relational database, you can aggregate any variety of formats and types of data including log files, multimedia like video and audio, text, images and more, then query all the data however you wish.
And, like all solutions that support log data analysis, there are numerous tools to aggregate the data including plugins specify to various OS syslogs, and insrting metadata for more efficient querying using aps like Loggerythm.
Additionally, the full solution includes a web interface for ordinary Users to access the data, but frankly you’ll likely need a fairly high level of technical expertise to be able to build your queries.
If you have a little coin to spend or data analytics software, Tableau is a popular, easy to use and learn (relatively speaking) for what I imagine to be your needs, Splunk is also very popular for the next step larger.
TSU