Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Problem getting data to a report file.
Top Forums Shell Programming and Scripting Problem getting data to a report file. Post 12179 by Cameron on Thursday 20th of December 2001 04:39:17 PM
Old 12-20-2001
Problem getting data to a report file.
Hi all,

I'm trying in vain to workout how I can generate a report from a months worth of files that get created every day. There is one file per day and each daily file contain the output from a df -v command.

With the following section of code ...
Code:
  for xdffile in $1$2/df??
    do

      echo $xdffile
      # Aquire date of file being read.
      xdfdd=`echo $xdffile | cut -c31-32`
      xdfmm=`echo $xdffile | cut -c21-23`
      xdfyy=`echo $xdffile | cut -c24-27`
      xdfdate="$xdfdd/$xdfmm/$xdfyy"
  ##  echo "$xdfdate"

      # Aquire details of file being read.
      grep "/" $xdffile > $xdffile\.temp
      cat $xdffile\.temp
      while read discfile
        do

          xmnt=`echo "$discfile" | cut -f1 -d" "`
          xspc=`echo "$discfile" | cut -f6 -d" "`
          echo $xmnt $xspc

        done < $xdffile.temp
      rm $xdffile.temp

    done  ## End-of (for xdffile in $1$2/df??)

I can produce the following output to the console ...
Code:
/amadeus_stats/disc/Nov2001/df29
/          /dev/root              6000002   3243220   2756782    55%
/stand     /dev/boot                80000     27124     52876    34%
/u         /dev/u                12896000  10740718   2155282    84%
/u1        /dev/u1               20000000   9877234  10122766    50%
/u2        /dev/u2               31048858  12037908  19010950    39%
/x1        /dev/x1               26871358   6815596  20055762    26%
/x2        /dev/x2               26871358  14498316  12373042    54%
/x3        /dev/x3               26871358  23092756   3778602    86%
/ 55%
/stand 34%
/u 84%
/u1 50%
/u2 39%
/x1 26%
/x2 54%
/x3 86%
/amadeus_stats/disc/Nov2001/df30
/          /dev/root              6000002   3251368   2748634    55%
/stand     /dev/boot                80000     27124     52876    34%
/u         /dev/u                12896000  10764106   2131894    84%
/u1        /dev/u1               20000000   9878108  10121892    50%
/u2        /dev/u2               31048858  12039694  19009164    39%
/x1        /dev/x1               26871358   6854662  20016696    26%
/x2        /dev/x2               26871358  14686220  12185138    55%
/x3        /dev/x3               26871358  23243320   3628038    87%
/ 55%
/stand 34%
/u 84%
/u1 50%
/u2 39%
/x1 26%
/x2 55%
/x3 87%

My problem is that I'd like to send the percentages(%'s) to a report in the following manner.
Code:
-  Date     - / - /stand - /u  - /u1 - /u2 - /u3 - /x1 - /x2 - /x3 -
28/Nov/2001  54%    34%    75%   66%   45%   61%   55%   22%   80%

Any tips?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Please help !!!!Problem with data file

I have a 1 million record file and in there i have 580 bad records meaning like they were spread on to 2 lines and is making my process fail as it is expecting single line records. How can i correct this records spread into 2 lines into single line or how i can writer these records into a new... (34 Replies)
Discussion started by: dsravan
34 Replies

2. UNIX for Dummies Questions & Answers

create data file from report file

Dear Ones, kindly help me to create a data file from the report file as shown here under( i am new one to unix KNOW BASIC COMMANDS) file:rama.prt (ist record)(3 to 4 lines of text with different filed names) Name :M.LALITHA DOB:12/11/45 DESG :JA(P) STANO:300175 ... (3 Replies)
Discussion started by: cvvsnm
3 Replies

3. Shell Programming and Scripting

Problem in writing the data to a file in one row

Hi All I am reading data from the database and writing to temporary file in the below format. 1=XP|external_component|com.adp.meetingalertemail.processing.MeetingAlertEmail|EMAILALERTPUSH|32|4#XP |classpath|/usr/home/dfusr/lib/xalan.jar: /usr/home/dfusr/lib/xerces.jar: ... (2 Replies)
Discussion started by: rajeshorpu
2 Replies

4. Shell Programming and Scripting

C Shell problem: using a key from one file to find data in another

I've never written scripts (just switched from Ada to C++). I have a book that's over my head and a few examples, other then that I'm floundering. Everything here at work is being done in C Shell. None of the C++ programmers are experienced in shell scripting. I have a data file with the... (2 Replies)
Discussion started by: bassmaster
2 Replies

5. Shell Programming and Scripting

Compare and print out data only appear in file 1 problem

Below is the data content of file_1 and file_2: file_1 >sample_1 FKGJGPOPOPOQA ASDADWEEWERE ASDAWEWQWRW ASDASDASDASDD file_2 >sample_1 DRTOWPFPOPOQA ASDADWEEASDF ASDADRTYWRW ASDASDASDASDD I got try the following perl script. Unfortunately, it can't give my desired output result... (7 Replies)
Discussion started by: patrick87
7 Replies

6. Shell Programming and Scripting

Scan and change file data content problem

Input file >Read_1 XXXXXXXXXXSDFXXXXXDS (condition 1: After the last "X" per line, if the distance is less than or equal to 3 letter, replace those not "X" letter with "X") TREXXXXXXXSDFXXXXXDS (condition 2: Before the first "X" per line, if the distance is less than or equal to 3 letter,... (12 Replies)
Discussion started by: patrick87
12 Replies

7. Shell Programming and Scripting

Three Difference File Huge Data Comparison Problem.

I got three different file: Part of File 1 ARTPHDFGAA . . Part of File 2 ARTGHHYESA . . Part of File 3 ARTPOLYWEA . . (4 Replies)
Discussion started by: patrick87
4 Replies

8. Shell Programming and Scripting

Create a report for client with a text data file

Hi, I am an amateur bash scriptwriter and I need to write a script which creates a report in a formatted, easy to read table-like that is displayed to standard output. The script has to export the followings: Process ID,User Name, Command Name,Priority..... Now I have a file that I can see all... (3 Replies)
Discussion started by: bashily
3 Replies

9. Shell Programming and Scripting

Formatting Report and Reading data and fetching the details from contents file

Data I was trying to write shell script which will be return the output in the below format First i was trying to do these using sed. sed -n '/.ksh/p' mainksh.ksh sed -e 's/*\(.*\)/\1/g' mainksh.ksh $RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file. when i am... (0 Replies)
Discussion started by: rameshds
0 Replies

10. Shell Programming and Scripting

Outputting data from log file to report

I have a log file that looks like this. the lines are grouped. 2 lines per entry. M: 2019-01-25 13:02:31.698 P25, received network transmission from KI4EKI to TG 10282 M: 2019-01-25 13:02:35.694 P25, network end of transmission, 4.3 seconds, 1% packet loss M: 2019-01-25 13:02:38.893 P25,... (7 Replies)
Discussion started by: ae4ml
7 Replies

LEARN ABOUT CENTOS

sysstat

SYSSTAT(5)							Linux User's Manual							SYSSTAT(5)

NAME

       sysstat - sysstat configuration file.

DESCRIPTION

       This  file is read by sa1(8) and sa2(8) shell scripts from the sysstat's set of tools.  It consists of a sequence of shell variable assign-
       ments used to configure sysstat logging.  The variables and their meanings are:

       HISTORY
	      The number of days during which a daily data file or a report should be kept. Data files or reports older than this number  of  days
	      will be removed by the sa2(8) shell script.

       COMPRESSAFTER
	      Number of days after which daily data files are to be compressed, either by gzip or bzip2.

       SADC_OPTIONS
	      Options  that  should be passed to sadc(8).  With these options (see sadc(8) manual page), you can select some additional data which
	      are going to be saved in daily data files.  These options are used only when a new data file is created. They will be  ignored  with
	      an already existing one.

FILES

       /etc/sysconfig/sysstat

AUTHOR

       Sebastien Godard (sysstat <at> orange.fr)

SEE ALSO

       sadc(8), sa1(8), sa2(8)

       http://pagesperso-orange.fr/sebastien.godard/

Linux								  SEPTEMBER 2010							SYSSTAT(5)
All times are GMT -4. The time now is 11:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy