VMAX SRP Utilization Report & Upload to MySQL DB using Python

I had an opportunity to attend Python Basics Training imparted by Mr. Ashish Gulati. Ashish, a technology coach; was really good in explaining basics of language, data types and Pro & Cons of this language. The way he imparted knowledge was an unique experience. He was flexible to explain some of the real time use cases in data analytics, JSON, SSH connectivity etc.. and explained in detail about the various module’s functionality.

Thank much Ashish for the session, it was informative, very simple topics but effective learning experience, hands on coding was a big plus point. I have learned much that will assist me in my workplace. As an outcome, I have already started migrating from Perl to Python.  This blog is about my first attempt to write Python scripts @ work.

Scripts written in Python would run from several VMAX3 Enterprise Storage Management Servers located at various data centers.

Python_vmax_cap

Advertisements

IBM Storwize V7000 Snapshots Report

There was a requirement came to me to capture the snapshots details on an IBM Storwize V7000 storage. so, I wrote a simple PERL script to generate HTML report and send it to the stake holders and storage team via email. I’ve used the command ‘lsfcmap’ to list the snapshot details. Using PERL I’ve captured required output in desired order and format to suit our requirements.

Please find below report generated and sent over an email (split into two images for better readability)

SS1SS2

Script Caveats:

  1. Can run the script via scheduler or On-Demand
  2. Sorted based on descending order to list the oldest snapshots on top of the list
  3. Old reports are archived for future reference or troubleshooting purposes

Please let me know if you need the script to replicate for your V7K’s.

Fujitsu Eternus Storage Capacity Report Script

As mentioned in my previous post, here is the Fujitsu Eternus Storage Capacity Report script output.

We have used the below commands to get capacity information from Fujitsu arrays.

show disks

show raid-groups

show flexible-tier-pools

Using Perl, we have parsed the output to a HTML file which is being sent as a daily capacity utilization report. Please find the below report for reference.

Fujitsu

VMAX Storage Group Report

Here is the the simplest way to generate a simple VMAX Storage Group’s allocated capacity report.

Run the below command

symsg -sid 1234 list -v > sglist.txt

Above command show each SG’s information in details along with Devices, type and capacity. We’ve redirected the output to a text file called ‘sglist.txt’. To produce a simple report using the above output; we need to use the below grep command.

grep ‘Name:\|2-way\|TDEV’ sglist.txt > out.txt

Above command greps lines having name of storage group, devices with 2-way mirror config and thin devices which are redirected to another text file called ‘out.txt’. We can see the devices with Status, capacity etc… which is sufficient to produce / calculate allocated storage capacity.