August 20, 2010

We do have some customers, who get charged on a monthly basis for their SAN usage. We already had “reporting” in place, but that wasn’t very flexible. So I went ahead and rewrote the current reporting script from scratch, and this is what I’ve come up with:

#/bin/bash

# LICENSE:     GNU General Public License v2. (see LICENSE.txt)
# COPYRIGHT:   Copyright 2010 Christian Heim &lt;christian.heim@barfoo.org&gt;

svc_sshkey=&quot;~/.ssh/svc-id_dsa&quot;
svc_addr=&quot;10.144.0.150&quot;
svc_user=&quot;admin&quot;

if [ -z $1 ] ; then
  echo &quot;Please rerun this script with some kind of filter value&quot;
  echo &quot;(for example &#039;$0 NAS&#039;)&quot;
  exit 1
else
  filter=$1
fi

IFS=&quot;
&quot;

DISK=&quot;$( ssh -i $svc_sshkey -l $svc_user $svc_addr svcinfo lsvdisk -nohdr -bytes -delim : 
          | egrep -i &quot;V.*$filter&quot; | cut -d: -f2,8 | sort )&quot;

# Get a unique list of systems
SYSTEMS=&quot;$( echo $DISK | sed &quot;s, ,n,g&quot; | cut -d  -f1 | sed &#039;s,^V,,&#039; | cut -d_ -f1 | sort -u )&quot;

for system in $SYSTEMS ; do
  VDISKS=&quot;$( echo $DISK | sed &quot;s, ,n,g&quot; | grep $system | sed &quot;s,:,: ,&quot; )&quot;
  SYSTEM_TOTAL=&quot;$( echo $DISK | sed &quot;s, ,n,g&quot; | grep $system | cut -d: -f2 | awk &#039;{SUM += $1} END { printf &quot;%.2f&quot;, SUM }&#039; )&quot;
  for vdisk in $VDISKS ; do
    NAME=&quot;$( echo $vdisk | cut -d: -f1 )&quot;
    SIZE=&quot;$( echo $vdisk | cut -d: -f2 | sed &quot;s,^ ,,&quot; )&quot;
    GB_SIZE=&quot;$( echo &quot;$SIZE / 1024 / 1024 / 1024&quot; | bc )&quot;
    if [ $GB_SIZE -eq 0 ] ; then
      GB_SIZE=&quot;$( echo &quot;scale=2; $SIZE / 1024 / 1024 / 1024&quot; | bc )&quot;
      GB_SIZE=&quot;${GB_SIZE/./0.}&quot;
    fi
    echo &quot;$NAME: ${GB_SIZE/./,} GB&quot;
  done
  SUB_TOTAL_SYSTEM=&quot;$( echo &quot;scale=2; $SYSTEM_TOTAL / 1024 / 1024 / 1024&quot; | bc )&quot;
  echo &quot;SUB TOTAL: ${SUB_TOTAL_SYSTEM/./,} GB&quot;
  echo
done

TOTAL=&quot;$( echo $DISK | sed &quot;s, ,n,g&quot; | cut -d: -f2  | awk &#039;{SUM += $1} END { printf &quot;%.2f&quot;, SUM }&#039; )&quot;
TOTAL=&quot;$( echo &quot;scale=2; $TOTAL / 1024 / 1024 / 1024&quot; | bc ) GB&quot;

echo &quot;------------------------------------------------&quot;
echo $TOTAL

exit 0

#/bin/bash

# LICENSE: GNU General Public License v2. (see LICENSE.txt)

svc_sshkey="~/.ssh/svc-id_dsa"

svc_addr="10.144.0.150"

svc_user="admin"

if [ -z $1 ] ; then

echo "Please rerun this script with some kind of filter value"

echo "(for example '$0 NAS')"

exit 1

else

filter=$1

IFS="

DISK="$( ssh -i $svc_sshkey -l $svc_user $svc_addr svcinfo lsvdisk -nohdr -bytes -delim :

| egrep -i "V.*$filter" | cut -d: -f2,8 | sort )"

# Get a unique list of systems

for system in $SYSTEMS ; do

VDISKS="$( echo $DISK | sed "s, ,n,g" | grep $system | sed "s,:,: ," )"

SYSTEM_TOTAL="$( echo $DISK | sed "s, ,n,g" | grep $system | cut -d: -f2 | awk '{SUM += $1} END { printf "%.2f", SUM }' )"

for vdisk in $VDISKS ; do

NAME="$( echo $vdisk | cut -d: -f1 )"

SIZE="$( echo $vdisk | cut -d: -f2 | sed "s,^ ,," )"

GB_SIZE="$( echo "$SIZE / 1024 / 1024 / 1024" | bc )"

if [ $GB_SIZE -eq 0 ] ; then

GB_SIZE="$( echo "scale=2; $SIZE / 1024 / 1024 / 1024" | bc )"

GB_SIZE="${GB_SIZE/./0.}"

echo "$NAME: ${GB_SIZE/./,} GB"

done

SUB_TOTAL_SYSTEM="$( echo "scale=2; $SYSTEM_TOTAL / 1024 / 1024 / 1024" | bc )"

echo "SUB TOTAL: ${SUB_TOTAL_SYSTEM/./,} GB"

echo

done

TOTAL="$( echo $DISK | sed "s, ,n,g" | cut -d: -f2 | awk '{SUM += $1} END { printf "%.2f", SUM }' )"

TOTAL="$( echo "scale=2; $TOTAL / 1024 / 1024 / 1024" | bc ) GB"

echo "------------------------------------------------"

echo $TOTAL

exit 0

I gotta say, once again I learned a lot … two new things about awk!

I know the report itself doesn’t look *that* pretty, but it serves a purpose!

S	M	T	W	T	F	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

Day: August 20, 2010

SAN reporting