Project
Description
MyTSMreport is a Project that use a Mysql database to store the account information from a Tivoli Storage Manager
and show them on web pages through PHP scripts in tables and graphs.
Features
- Web interface, all information accessible with a browser
- Entirely written in PHP 4
- Use Mysql Engine to store informations.
- Use JPgraph to draw custom graph.
- Detailed Features .
- Online DEMO .
Screenshots
- Basic menu (could be outdated, check demo for changes)
- Platform Distribution in a Pie graph
- Nodes Lifespan in a Gant graph
- Monthly report for all TSM operations in a Line graph
- Backup/Archive in a Bar graph
- Top 10 nodes Occupancy report: GBStored/Files Stored in a Line graph on X axis you'll have your nodes names.
- Top 20 Nodes for MB_Moved in a custom period of time, and total time for their sessions in a Line + Bar graph. on X axis you'll have your nodes names.
- Top 20 Nodes for space occupancy in a 3d pie graph (took from the demo)
- Occupancy Trend with total space moved for every day
- Wait time distribution for a day in a line Graph.
- Backup/Restore activity for top nodes over a custom period of time.
- Tape usage over a custom period of time.
Requirements
 |
In
order to be able to use the MyTSMReport should be acquainted with LAMP platform, and of course know a bit of TSM administration. |
| |
|
|
You
need the following software: |
|
-
Unix Platform (first tested will be Linux) |
|
-
Mysql 3.23xx or 4.0.xx |
|
-
PHP 4.3.x compiled with support for Mysql and GD (for graphs) |
|
-
A Web server, i'll use Apache 2.xx in my test.
|
| |
|
Download:
You can download the last release from Sourceforge .
I'm working on:
- Documentation - More and better.
- Custom hostgroups creation, usable in the query.
- Support for multiple TSM Server.
- Porting on WinXX server.
- Different access for user and admin
- Compare custom periods / custom hosts.
- Make the database functions portable on other DB (oracle, DB2...).
I've ended work on:
- Show TSM db utilization.
- Show tape usage in Tables and graphs, now with reclamation info
- Add an Online Demo.
- Add Online Help for every form.
- Show every Node occupancy and number of files via a select to TSM Server
- Store (for every day ) nodes occupancy and number of files
- Update the DB with daily operations via a cron job.
- Create the DB and all the tables via an automated procedure.
- Basic features: Show informations on tables and graphs.
If you have some idea or some features you'd like to see email me or leave a message on the forum
For help on Mytsmreport you can use the above forum, for TSM help you can go to IBM: ADSM back-up Forum
|
