Pulling Disk Information to Excel Spreadsheet


#1

I am wanting to take the disk information that nagios collects in it’s checks and get that put into a spreadsheet. I have a .xls spreadsheet with existing information and was wondering if there was anything that anyone had done that would take the disk info (free, total, etc) and put it in a spreadsheet. Either it’s own spreadsheet or in a specific place in an existing one. Any help will be greatly appreciated. Thank you in advance.


#2

grep, awk & Co are your friends :slight_smile:

Take the nagios log file, grep it for the check you are looking for, take the data, rewrite it in the format you need and get a cvs output file… then open that file in your spreadsheet program.


#3

First, your signature is amazing. Found The IT Crowd a few years ago, purely hysterical.

But would there be a way to script that process? I’m thinking not automatically, but if we need reports on the 20th, we kick it off the 19th or something and let it write? You did give me some food for thought though. Thanks for all the help.


#4

:slight_smile:

[quote]
But would there be a way to script that process? I’m thinking not automatically, but if we need reports on the 20th, we kick it off the 19th or something and let it write? You did give me some food for thought though. Thanks for all the help.[/quote]

Depends on what you need… you could run it when you need it using a parameter telling it how many days worth of logs to check… :slight_smile:
or directly use nagiosgraph and have the disks used space directly graphed (depends on what you need to do exactly)