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

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.

'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.

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.

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.

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.