Combining daily S.M.A.R.T data in a meaningfull sheet (2 problems)

Vitolio · #1 07-09-2013, 11:24 AM

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,

Vitolio · #2 07-10-2013, 08:58 AM

Right: I still can't

I have uploaded the sample log to pastebin.com: http://pastebin.com/yB45KEcg

As I tried to explain, the only data relevant in this log would be:

The disk serial number:

Code:

WD-WMAV02649841

And then this data (so, this is per disc):

Code:

ID# ATTRIBUTE_NAME          FLAG     VALUE WORST THRESH TYPE      UPDATED  WHEN_FAILED RAW_VALUE
  1 Raw_Read_Error_Rate     0x002f   200   200   051    Pre-fail  Always       -       0
  3 Spin_Up_Time            0x0027   253   253   021    Pre-fail  Always       -       8500
  4 Start_Stop_Count        0x0032   100   100   000    Old_age   Always       -       249
  5 Reallocated_Sector_Ct   0x0033   200   200   140    Pre-fail  Always       -       0
  7 Seek_Error_Rate         0x002e   100   253   000    Old_age   Always       -       0
  9 Power_On_Hours          0x0032   096   096   000    Old_age   Always       -       3390
 10 Spin_Retry_Count        0x0032   100   100   000    Old_age   Always       -       0
 11 Calibration_Retry_Count 0x0032   100   253   000    Old_age   Always       -       0
 12 Power_Cycle_Count       0x0032   100   100   000    Old_age   Always       -       55
192 Power-Off_Retract_Count 0x0032   200   200   000    Old_age   Always       -       4
193 Load_Cycle_Count        0x0032   200   200   000    Old_age   Always       -       244
194 Temperature_Celsius     0x0022   124   099   000    Old_age   Always       -       28
196 Reallocated_Event_Count 0x0032   200   200   000    Old_age   Always       -       0
197 Current_Pending_Sector  0x0032   200   200   000    Old_age   Always       -       0
198 Offline_Uncorrectable   0x0030   200   200   000    Old_age   Offline      -       0
199 UDMA_CRC_Error_Count    0x0032   200   200   000    Old_age   Always       -       7
200 Multi_Zone_Error_Rate   0x0008   200   200   000    Old_age   Offline      -       1

I would really appreciate extremely very much your help :-)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Daily Task Sheet - help	Malissa1578	Excel Programming	3	03-21-2013 09:35 AM
data linked from excel sheet	megatronixs	Word VBA	1	08-19-2012 11:09 PM
sheet 2 data highlight in sheet 1	gsrikanth	Excel	1	04-21-2012 06:25 PM
Looking up data and populate a new sheet	Boatwrenchv8	Excel	4	04-13-2012 05:56 PM
Link data from embedded excel sheet	rwbarrett	Word	1	05-27-2011 02:05 AM