Holy smokes :O that worked perfectly. The last three are where I added the date. Thanks so much.

lun,date,sdd sz,hdd sz
serv01_lun01.out,1.06GB,248.94GB
serv01_lun01.out,1.06GB,248.94GB
serv01_lun01.out,1.06GB,248.94GB
serv01_lun01.out,960.00MB,249.06GB
serv01_lun01.out,08/25/12,960.00MB,249.06GB
serv01_lun01.out,08/26/12,896.00MB,249.12GB
serv01_lun01.out,08/27/12,896.00MB,249.12GB

---------- Post updated at 03:03 PM ---------- Previous update was at 02:56 PM ----------

I have a perl script I use to pull down Cisco switch info and use a perl DB mod to shove it into a DB. Might do that with data as well.

At present, wanted a quick way to put it into Excel, next is to put it on a webpage/dashboard, then I'll look at the DB option.

---------- Post updated at 03:16 PM ---------- Previous update was at 03:03 PM ----------

Now that I'm reading the comments, I see what you guys mean. This actually might be a better way overall to report on the data. Create something like:

Code:

serv01_lun01
08/25/2012,100,250
08/26/2012,105,245
08/27/2012,110,240

serv12_lun03
08/25/2012,55,100
08/26/2012,60,95
08/27/2012,60,95

Can the awk script be easily modified to do something like this instead?

Dunno...now that I'm thinking more about DB stuff, wondering how my columns might look. the LUN name will always be the same. The date and sizes are what are changing.