G'evening
I have breaking my head for days over a problem I am having, and I was hoping somebody who has mercy with a noob like me would help me out
I will be in debt for this, and I always pay off my debts whenever I can
My situation is this:
- I have a NAS (Network Attached Storage, which is a file server within my LAN). Within it are 8 disks. They are giving me problems. I need to monitor these disks.
- The NAS is based on Linux, and there is a tool for monitoring hard disk Self Monitoring Analysis and Reporting (hence: S.M.A.R.T, more information here: https://en.wikipedia.org/wiki/S.M.A.....T._attributes).
- What I want to do is run smartctl -a (the command that checks the SMART data), daily, for a week, for each of the 8 disks. I will do this daily, manually. I want to see if the SMART-characteristics increase over time. (And with SMART-characteristics I mean the values of the "Known SMART characteristics', the lines in the table in the wiki article, for example the 0x01, 0x02, and so on).
- So, as you can see, there are some 60 SMART parameters. Given 8 disks and 7 days that means 60x8x7 = 3360 values over one week.
I have attached an example SMART-report that the SMART-tool will output (again, I will run that report manually, and so I will have 8 reports every day, 56 reports after one week, each report giving me the values of about 60 parameters for that day). As you can see, it does not contain all the parameters that the wikipedia article lists, but less. I am only interested in the serial number (WMAY) for indentification, and then next the SMART values that it does list (the content in the middle of the document, so from ID# 1 to ID# 200).
My problems are twofold:
- Is there an easy way to get this data into Excel? I don't want to type it in by hand, because then I would have to quit my day time job and can't feed my wife and children anymore ().
- How would one construct a meaningful Excelsheet out of this, which can be used to easily monitor the evolution of each disk over time (in a graph)? As I get stuck at: Excel is 2 dimensions (rows x columns), yet I have three (disks, days, SMART-parameters)?
I am stuck at this for days, and I was hoping somebody would be so kind to help me out. Again, I would be in your debt for this, and I always intend to pay my debts
Thank you in advance for your reply,
Bye,