In continuation to my previous blog on charting epoch time series MySQL data using PHP. I started exploring generating better reports from the DB.
Inspired by the EMC SRM (M&R) storage capacity reports in PDF format, I thought of doing similar kind of reports “in-house” which should be simple yet standard to be shared with customers. I would like to thank Sapan Kumar from EMC who thought me so many things about EMC’s SRM (M&R) custom reporting features.
We have the data in MySQL DB and wanted to use the PDF module in PHP to generate reports. But which module is suitable and easy to use?
After rigorous testing with FPDF and DOMPDF, I decided to use FPDF (not sure why :p) and it produced nice reports indeed!
Please find sample reports screenshot produced below for reference. You could see the capacity reports of VNX and VMAX storage arrays.
If interested, please reach out to me to get the PHP code. Thanks for stopping by… Please leave your comments / suggestions.
Both Brocade webtools, Cisco GUI and VNX Unisphere requires Java enabled browsers to manage and administer the SAN or storage devices. To enable java support on Linux, we need to install platform compatible JRE (Java Runtime environment).
Below command can be used to install JRE on Debian / Ubuntu like Linux systems.
aptitude install icedtea-plugin
After installation of above package along with its dependencies, we can access the respective Java based GUI tools from Debian / Ubuntu Linux. We can use respective package management software to install the same package on Redhat/ Fedora/ CentOS/Suse etc… This enables storage admin like me to use the respective management suite from my favorite OS.
If you are unable to see the login screen after entering IP address in the browser and end up with blue screen.. chances are due to JAVA Run Time. VNX Unisphere does not work in versions 1.7 and 1.8.
Download archived version of JAVA 1.6 update 26 and above from here. Install along with the latest version and restart your PC / server for the best results (can’t help its window$).
After restart we should be able to see login screen and can manage the VNX array!