MySQL PHP Generating reports in PDF format

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.

Access Brocade Webtools , Cisco GUI and VNX Unisphere from Linux

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.

Linux ROCKS!!!

2015-09-10 10_00_32- - Remote Desktop Connection