On Mar 21, 10:40 am, Ed Morton <mor...@[EMAIL PROTECTED]
> wrote:
> On 3/21/2008 9:15 AM, spacegoose wrote:
>
>
>
> > On Mar 21, 12:04 am, Ed Morton <mor...@[EMAIL PROTECTED]
> wrote:
>
> >>On 3/20/2008 11:36 PM, spacegoose wrote:
>
> >>>i have a program that prints out a formatted df command
> >>>by sorting and grepping and using awk to print it out.
>
> >>>it basically executes df -h | grep whatever | sort -n +5 and then
> >>>awks
> >>>to a nice printout like:
>
> >>>disk size capacity
> >>>------------------
> >>>foo 20gb 70%
> >>>moo 40gb 25%
> >>>bar 20gb 70%
>
> >>>i'd like to add a new column "accounts" to this print out.
>
> >>>the no. of accounts is derived from a command:
> >>>awk {'print $5'} myFile |sort |uniq -c |sort -nr
>
> >>>which prints rows like:
>
> >>>450 foo
> >>>300 moo
> >>>104 bar
>
> >>>i want to integrate this command into the formatted df program's
> >>>output.
> >>>i can't figure out how to appropriately append the "account count"
> >>>column from the myFile command, to the appropriate row of the
> >>>formatted df output,
> >>>e.g. where col 1 from the formatted df output matches col 2 of the
> >>>myFile command.
>
> >>>so it looks like this:
>
> >>>disk size capacity accounts
> >>>---------------------------
> >>>foo 20gb 70% 450
> >>>moo 40gb 25% 300
> >>>bar 20gb 70% 104
>
> >>>Thanks for any hints!
> >>>sg
>
> >>$ cat file1
> >>450 foo
> >>300 moo
> >>104 bar
>
> >>$ cat file2
> >>disk size capacity
> >>------------------
> >>foo 20gb 70%
> >>moo 40gb 25%
> >>bar 20gb 70%
>
> >>$ awk '
> >>NR==FNR{acct[$2]=$1;next} FNR==1{sfx=" account"}
FNR==2{sfx="--------"}
> >>FNR>2{sfx=" "acct[$1]} {print $0 sfx}' file1 file2
> >>disk size capacity account
> >>--------------------------
> >>foo 20gb 70% 450
> >>moo 40gb 25% 300
> >>bar 20gb 70% 104
>
> >>but I expect there's a much simpler way to get your desired output
using awk on
> >>your raw output rather than doing all that post-processing with other
tools
> >>first. If you provide your "df -h" output and "myFile" contents that
got you the
> >>data above, we could probably help.
>
> >> Ed.
>
> > Thanks Ed,
>
> > I definitely want to work with the output rather than files (except
> > reading from myFile).
> > Fere's the df awk:
>
> > df -h | grep dsk | sort +5 | awk '
>
> > BEGIN {
> > printf("%-30s%12s%10s%10s\n\n", "File System", "bytes", "capacity",
> > "accounts")
> >
printf("-------------------------------------------------------------------
> > \n")
> > T2 = 0
> > T3 = 0
> > T4 = 0
> > }
>
> > {
> > printf("%-30s%12s%10s%10s\n", $6, $2, $5, "# accts")
> > T2 += $2
> > T3 += $3
> > T4 += $4
> > }'
>
> You never use T2, T3, and T4.
>
> I asked you to post the df -h output and the contents of MyFile so we're
not
> guessing but try this:
>
> df -h | sort +5 | awk '
> BEGIN {
> printf "%-30s%12s%10s%10s\n\n", "File System", "bytes", "capacity",
"accounts"
> print
"-------------------------------------------------------------------"}
>
> NR==FNR{ accts[$5]++; next }
> { printf "%-30s%12s%10s%10s\n", $6, $2, $5, accts[$6] }' MyFile -
>
> If that doesn't do what you want, post what I suggested so we can see
what
> you're working with.
>
> Ed.
Thanks for the help - the above did not work.
Here's the output of my df awk
File System bytes capacity accounts
-------------------------------------------------------------------
/ 19G 53%
/local/ds/xp0 200G 71%
/local/ds/xp1 200G 66%
/local/ds/xp10 200G 66%
/local/ds/xp11 200G 68%
/local/ds/xp12 200G 67%
here's a sample from myFile -
611 65114 2008/03/20 15:31 xp6 256000 user/xxx/INBOX
134 4805 2008/03/20 13:41 xp7 256000 user/yyy/INBOX
398 13403 2008/03/19 14:05 xp7 256000 user/zzz/INBOX
367 31508 2008/03/20 15:19 xp8 256000 user/aaa/INBOX
45 1759 2006/02/18 11:05 xp9 256000 user/bbb/INBOX
Of which:
I can derive the number of accts on each partition (xp#) from this:
awk {'print $5'} myFile |sort |uniq -c |sort -nr
A sample of its output looks like:
2145 xp30
2131 xp3
2129 xp33
2126 xp6
2123 xp32
I want to get the # in the first column to show up appropriately in
the df output (where the partitions, e.g.col2 here, matches col1 - I
now see there are /slashes/ to contend with...).
Thanks again,
sg
|
