need some idea to automate report generation in linux and solaris servers
Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
Kind of depends on your requirements like for instance if host-based modification is allowed, if you need push or pull, etc, etc. Logging in is not necessary if you use SNMP with Nagios, Zenoss, GroundWork Core, OpenNMS or whatever tool or suite you fancy.
my task is to take those parameters in an excel sheet
From reading your reply I'll assert that you neither have the inclination to suggest and discuss improvements nor that you are in a position to do so. That is a pity because the output you have to work with is not suitable for useful inclusion without modification. You will have to put in a lot of effort. Start by listing the common report file location(s) (/var/www, /var/log, /tmp), file ownership and access rights (0660, 0644, root, unprivileged user), the way(s) you access report data (SSH, telnet, HTTP, etc, etc) and how you think you should modify the report to fit a CSV file. Actual code preferred but any pseudo code should do.
Personally, I'd start asking for help in a suitable format, such as [code][/code] tags around 75 lines of code, or script(s), or script output...
The markup is minimal, where rendered text can be problematic off the clipboard.
Linux and Solaris servers...
ssh keys will make this whole task seamless and fluid.
Do you have any that can help automate this?
If you are up for expanding your skill as either as a programmer, or a decent sysadmin, this sounds like a job for snmp, or Perl.
If it were me and I didn't know snmp, or Perl, I'd process the remote script by 'running' it from your workstation, going in over key-based ssh
Nobody is going to read a spreadsheet with 200 rows every day of this sort of stuff.
I believe you'd be better off either
1. graphing it eg Cacti
2. pump it into a DB, then you/someone can write a nice web gui to generate random reports based on input params eg servername and/or the values of certain values you've collected.
Of course see post #2 if you want to to be alerted if a param is exceeded.
In other words, exactly why do you want to do this; what will the data be used for; under what circumstances?