1

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

1 Answer 1

2

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:

enter image description here

Source: http://oss.oetiker.ch/rrdtool

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .