LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This 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!

Notices

Reply
 
Search this Thread
Old 02-19-2008, 06:38 AM   #1
ajeetraina
Member
 
Registered: Jun 2007
Location: India
Distribution: Ubuntu,Red Hat, Fedora
Posts: 292

Rep: Reputation: 30
Report Generating Tool ????


Hello guys,

I have been helped everytime I post any query and hope this time too.
All I need your suggestion regarding the tools for report generation.
We are 10 admin members who are having different role durign the Server installation.Whenevre a request for installing a new server comes it takes 3-4 days for complete installation.Member2 installs informix as soon as member1 completes installation of RHEL.In this way every member has respective job to perform.My Manager wants to track the % completion and time accounting for the whole project.
All I need a tool which could produce report at last showing the dedicated time with their task.
I tried to search tool in php/mysql but couldnt find the relevant tool
Pls Help
 
Old 02-19-2008, 07:26 AM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,033

Rep: Reputation: 755Reputation: 755Reputation: 755Reputation: 755Reputation: 755Reputation: 755Reputation: 755
You may want to look at the last utility; man last, and see if that might at least get you started. Other than that, take a look at sa1, sa2, sar and associated system activity information utilities.
 
Old 02-19-2008, 08:04 AM   #3
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,118
Blog Entries: 54

Rep: Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787Reputation: 2787
'last' shows the duration but from a project management POV, time spent on the system does not necessary equal task time. One could be logged on for days doing nothing but wait() or sleep(). From experience I'd say getting task time logged is more of a discipline thing. For planning and reporting there is a wide variety of project management software like Taskjuggler, GanttProject, (mr?)Planner(?). Freshmeat and Sourceforge are good startingpoints for finding some and searching LQ might give some opinions on some SW.
 
Old 02-19-2008, 09:05 AM   #4
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian Squeeze
Posts: 5,764

Rep: Reputation: 306Reputation: 306Reputation: 306Reputation: 306
OpenOffice.org Base has a report wizard for creating reports relative to a database. OO.org Base can connect to MySQL and open an existing database. Once the database is open, use the report wizard to create the report.

Beyond that, you should look into project management software. You can plan a project (how much time you think each phase should take to complete), how much time is actually used (compared to the project plan), show % complete at any time assuming the data is current, and probably also generate a report.

Direct your web browser at www.google.com/linux, and search for "project management". You will find open source, free (but not open source), and commercial software.
 
Old 02-19-2008, 11:34 PM   #5
ajeetraina
Member
 
Registered: Jun 2007
Location: India
Distribution: Ubuntu,Red Hat, Fedora
Posts: 292

Original Poster
Rep: Reputation: 30
LEt me elaborate more clearly may be someone can come up with new ideas therewith.
At present We have a webpage where all the developers working raise a call.That Call is now received by our Infrastructure Team where we are 10 admin.In this webpage we have different things :
1. Inventory management link which now one of senior member enter manually through perl/html/mysql scripts.
2. When developoer raise a call that gets automatically displayed on every admin page (need to refresh) and same as mail too
3. That site too have links for overall call status and assigned to particular admin
4.For tracking the host alive/off status we have different tool called nagios.
5. For report generation tools like php report is being implemented.

I am in search of certain software which can accomodate evrything under one platform..Say that tool should have minimal stuffs like :
1.Inventory management and information datahouse.
2.Automatic Report Generation which I talked in teh first post
3.Calls from developer and assigning criteria


Pls help me in this regard.

Last edited by ajeetraina; 02-20-2008 at 12:02 AM.
 
Old 02-20-2008, 07:42 AM   #6
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,033

Rep: Reputation: 755Reputation: 755Reputation: 755Reputation: 755Reputation: 755Reputation: 755Reputation: 755
Some folks use Bugzilla for this sort of thing; maybe not the inventory management part exactly (there are ways to do that with Bugzilla) but certainly for all the rest.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RPM Report / Comparison tool muz_j Linux - Newbie 2 08-30-2007 09:32 PM
Bug report tool in Ubuntu 6.10 pppaaarrrkkk Linux - Newbie 0 07-25-2007 08:37 AM
Any reliable report generating tool for squid proxy? Niceman2005 Linux - Software 2 03-08-2006 02:20 AM
Bind tool for automatically generating reverse zone files p0rt Linux - General 0 01-07-2005 04:33 AM
Tool to report on Kernel options? dkraut Linux - General 1 03-01-2004 04:40 PM


All times are GMT -5. The time now is 09:28 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration