Required formatted output on mail for disk utilization


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Required formatted output on mail for disk utilization
# 1  
Old 01-05-2018
Required formatted output on mail for disk utilization

Hi Experts,

Could you pls help with below query

I have written below script to capture disk utilization and then send the output on mail. But getting unformated output on mail

Code:
#!/bin/bash 
echo "Hi Sur,">dfoutput.csv
printf '\n' >>dfoutput.csv
echo "Please find BAYSQUAR2 filesystem details as below. ">>dfoutput.csv
printf '\n' >>dfoutput.csv
df -hP /Baysquar2/undo /Baysquar2/redo1 /Baysquar2/redo2 /Baysquar2/temp /Baysquar2/arch01 /Baysquar2/disk04 /Baysquar2/disk03 /Baysquar2/disk02 /Baysquar2/disk01 /Tat
icr/data04 /Taticr/data05 /Baysquar2/disk08 /Baysquar2/disk07 /Baysquar2/disk06 /Baysquar2/disk05 /Baysquar2/arch02_new /Baysquar2/disk09 /Baysquar2/disk10 /Baysquar2/
disk11 /Baysquar2/disk12 /Baysquar2/disk13|awk '{printf "%-5s|%-5s|%-5s|%-5s|%5s\n", $2,$3,$4,$5,$6}' >>dfoutput.csv
printf '\n' >>dfoutput.csv
echo "Regards">>dfoutput.csv
echo "Unix Team">>dfoutput.csv
cat dfoutput.csv|mailx -s "BAYSQUAR2 172.17.5.199(Tata-Icr2)" xyz@abc.com

Current output(irregularize)
Code:
Size |Used |Avail|Use% |Mounted
99G  |96G  |3.2G |97%  |/Baysquar2/undo
50G  |12G  |39G  |23%  |/Baysquar2/redo1 50G  |9.2G |41G  |19%  |/Baysquar2/redo2 99G  |93G  |6.2G |94%  |/Baysquar2/temp
99G  |5.2G |94G  |6%   |/Baysquar2/arch01
148G |147G |1.4G |100% |/Baysquar2/disk04 148G |147G |1.4G |100% |/Baysquar2/disk03 168G |167G |1.2G |100% |/Baysquar2/disk02 296G |296G |9.0M |100% |/Baysquar2/disk01 1.2T |867G |339G |72%  |/Taticr/data04
1008G|719G |290G |72%  |/Taticr/data05
788G |785G |2.5G |100% |/Baysquar2/disk08 540G |536G |3.7G |100% |/Baysquar2/disk07 493G |491G |1.5G |100% |/Baysquar2/disk06 542G |539G |2.7G |100% |/Baysquar2/disk05 247G |91G  |144G |39%  |/Baysquar2/arch02_new
1008G|957G |619M |100% |/Baysquar2/disk09 956G |1.7G |100%

Below is expected output which i need to have
Code:
Size |Used |Avail|Use% |Mounted
99G  |96G  |3.2G |97%  |/Baysquar2/undo
50G  |12G  |39G  |23%  |/Baysquar2/redo1
50G  |9.2G |41G  |19%  |/Baysquar2/redo2
99G  |93G  |6.2G |94%  |/Baysquar2/temp
99G  |5.2G |94G  |6%   |/Baysquar2/arch01
148G |147G |1.4G |100% |/Baysquar2/disk04
148G |147G |1.4G |100% |/Baysquar2/disk03
168G |167G |1.2G |100% |/Baysquar2/disk02
296G |296G |9.0M |100% |/Baysquar2/disk01
1.2T |867G |339G |72%  |/Taticr/data04

Regards
# 2  
Old 01-05-2018
Please show the contents of dfoutput.csv and a (partial) hexdump of it. I guess the problem might be on the receiving side. What's your mail client?
# 3  
Old 01-05-2018
I think it is because your df output that you are reading into awk may be split over multiple lines if the logical volume name or mount-mount are too long.


Before I worry about that, there are a lot of file IO redirections here and a big long linst making it rather messy. Would something like this this be neater?
Code:
#!/bin/bash

Target_dirs="\
/Baysquar2/undo   \
/Baysquar2/redo1  \
/Baysquar2/redo2  \
/Baysquar2/temp   \
/Baysquar2/arch01 \
..... etc.
/Baysquar2/disk13 \
"                                                        # Clear list of directories defined, and easy to adjust

{
echo "Hello"
echo
echo "Size |Used |Avail|Use% |Mounted"                   # Manually set the headings
for dir in "$Target_dirs"
do
   df -h $dir
done | grep -v "Filesystem"                              # .... plus whatever formatting needed here
echo
echo "Bye"
} > output_file                                          #  All output within the braces written as a single IO, reducing clutter too


This looks much cleaner to me so you can concentrate on your formatting.

For the formatting loop, perhaps this might work:-
Code:
while read lv size used avail usep mounted
do
   if [ -z "$mounted" ]
   then                                                   # Line is split, so shuffle everything over
      mounted="$usep"                                     # Maybe an array could be used to smarten this
      usep="$avail"                                       # to a single step
      avail="$used"
      used="$size"
      size="$lv"
   fi
   printf "%-5s|%-5s|%-5s|%-5s|%-s" "$size" "$used" "$avail" "$usep" "$mounted"
done < <(for dir in "$Target_dirs"                        # .... whatever
do
   df -h "$dir"
done | grep -v "Filesystem")

Of course, you could use awk for this, but you need to know what input you are really getting for each 'line' that whatever tool will use.

Is the output you have shared scraped from the email or is that what ends up in the file?

Can you share the output for a simple df -h /Baysquar2/* /Taticr/* or the more explicit:
Code:
df -hP /Baysquar2/undo /Baysquar2/redo1 /Baysquar2/redo2 /Baysquar2/temp /Baysquar2/arch01 /Baysquar2/disk04 /Baysquar2/disk03 /Baysquar2/disk02 /Baysquar2/disk01 /Tat
icr/data04 /Taticr/data05 /Baysquar2/disk08 /Baysquar2/disk07 /Baysquar2/disk06 /Baysquar2/disk05 /Baysquar2/arch02_new /Baysquar2/disk09 /Baysquar2/disk10 /Baysquar2/
disk11 /Baysquar2/disk12 /Baysquar2/disk13


Can you tell me if my suggestions help/hinder/confuse?




Thanks, in advance,
Robin
# 4  
Old 01-05-2018
Quote:
Originally Posted by rbatte1
I think it is because your df output that you are reading into awk may be split over multiple lines if the logical volume name or mount-mount are too long.
Shouldn't df -P (or df -hP) force one line per filesystem?
This User Gave Thanks to CarloM For This Post:
# 5  
Old 01-05-2018
I guess this is happening at the email client.

E.g. Microsoft Outlook by default removes extra line breaks in plain text format. You will be able to see a warning "We removed extra line breaks from this message"

You can turn off this settings or send this email in table (Content-Type: text/html) format.
This User Gave Thanks to Yoda For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Required cpu , memory, df output in mail for multiple servers

I have prepared script which will collect cpu, memory and df out out for multiple server and send in one mail, but my script only run in one server, and when I send to mail, it shows in text format. it should be show actual format. if any one can help , that would be very grateful. script... (1 Reply)
Discussion started by: yash_message
1 Replies

2. Shell Programming and Scripting

Mail a formatted csv file

I have the below script i am getting the csv in garbled format.Please suggest the changes. SUNOS ####################################################################### ####MAIN SCRIPT ####################################################################### today=`date "+%m-%d-%Y ... (3 Replies)
Discussion started by: rafa_fed2
3 Replies

3. Shell Programming and Scripting

script to mail monitoring output if required or redirect output to log file

Below script perfectly works, giving below mail output. BUT, I want to make the script mail only if there are any D-Defined/T-Transition/B-Broken State WPARs and also to copy the output generated during monitoring to a temporary log file, which gets cleaned up every week. Need suggestions. ... (4 Replies)
Discussion started by: aix_admin_007
4 Replies

4. UNIX for Dummies Questions & Answers

Disk utilization

Hi, I have hundred folders under a fs /apps which is used by different users and they upload their data to these folders on a daily basis. Using du -sk gives me complete structure of the filesystem but i want to find out day to day utlization of the top ten highest accoriding to size wise ... (4 Replies)
Discussion started by: chetansingh23
4 Replies

5. Red Hat

Disk Utilization

Hi, Can anybody explain why my newly created 120G FS shows 100% utilization when only 113G of disk space has been used? ...... # df -h . Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg01-lvol0 119G 113G 0 100% /u02 #du -h /u02 16K ... (3 Replies)
Discussion started by: Duffs22
3 Replies

6. Infrastructure Monitoring

Disk Utilization between Global + Zone

Dear Gentleman in my environment I have Solaris10 OS Box in Global Zone with 136 GB and mount point from SAN Storage 500 GB (Orastorage) Zone1 mounted on /Zones folder with 66 GB when I run zpool list output -bash-3.00$ zpool list NAME SIZE ALLOC FREE CAP HEALTH... (0 Replies)
Discussion started by: Hosam
0 Replies

7. Red Hat

Disk Utilization is very high

Hi, I have monitored that disk utilization is very high on one of red hat linux VM. Would like to know how to find out that issue of high disk utilization is because of disk or Installed Application on that server is causing the problem. Regards, Manoj (1 Reply)
Discussion started by: manoj.solaris
1 Replies
Login or Register to Ask a Question