I need to write a shell script that takes some statistics related to system and those values should be redirected to a spreadsheet in share point which then presented as a graph. Which is the best way to redirect output of shell script to spreadsheet in share point that updates dynamically?
1 Answer
If you need a xlsx spreadsheet, take a look at this question where I present two packages to create such files. A simple script could take your bash
output to render a spreadsheet. I'd suggest to first look at this simple example (in perl
).
There is also a well known tool called RRDtool for such a task:
RRDtool (acronym for round-robin database tool) aims to handle time-series data like network bandwidth, temperatures, CPU load, etc. The data are stored in a circular buffer based database, thus the system storage footprint remains constant over time.
RRDtool can render your system metrics this way:
Source: http://oss.oetiker.ch/rrdtool