---------- Post updated at 03:03 PM ---------- Previous update was at 02:56 PM ----------
Quote:
Originally Posted by DGPickett
If you put it into a database daily, there is much less to format. If you format as you collect, in distributed collection scripts, bash could do all the parsing necessary to make each row. A cron on each host could ensure the data is collected same time every day, or even hourly, even if the network or report host is down. The report host could collect the files via ssh, rsync, rsh, ftp or they could NFS to the report host from local on the end host (not the other way around, see prior sentence).
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:
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.
Hi,
I have a perl script that prints some data in the form of a table (HTML table) Now, I want to be able to convert this data into a report on an Excel sheet. How can I do this?
Regards,
Garric (4 Replies)
I may have posted in the wrong section, either way I need some help.
And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here:
# This script sends Email acoording to command line arguments.
#... (1 Reply)
And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here:
# This script sends Email acoording to command line arguments.
# $1 - file to be attached (full path with name)
# $2 - file name as it... (1 Reply)
I have a spreadsheet in a folder that looks like this:
Sector1...Sector2...Sector3...Sector4...Sector5...Sector6...Sector7
SomeID....Title.......SomeID...SomeID....SomeID...SomeID....SomeID
OtherID...MyTitle....SomeID...SomeID....SomeID...SomeID....SomeID... (7 Replies)
Very new to UNIX, so still getting used to all this.
I made a Perl script where I want to create a spreadsheet file when extracting "data" from a text file.
Now, this works perfectly fine on my Windows OS since I'm using the Win32 libraries with Microsoft Excel, but when I want to try it out on... (0 Replies)
Hi
I can't seem to figure out why i keep getting this error. the Spreadsheet::PhaseExcel is installed on 3 servers and is working on only 2... the last one it is installed exactly the same way but I keep getting this error.
This is whats odd.
If i run this script as a normal user i get... (2 Replies)