Sponsored Content
Top Forums UNIX for Advanced & Expert Users Alternative to sort -ur +1 required Post 302712721 by DGPickett on Tuesday 9th of October 2012 04:18:11 PM
Old 10-09-2012
To do it in one pass, sort by user and then by time, and only print the first every time the user changes. To do it in one pass without sorting, store the time using a string addressable vector keyed to the user and overwrite it for later times.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

sort out the required data

Hi All, I have a file 1.txt which has the duplicate dns entries as shown: Name: 000f9fbc6738.net.in|Addresses: 10.241.66.169, 10.84.2.222,212.241.66.170 Name: 001371e8ed3e.net.in|Addresses: 10.241.65.153, 10.84.1.101 Name: 00e06f5bd42a.net.in|Addresses: 10.72.19.218,... (6 Replies)
Discussion started by: imas
6 Replies

2. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies

3. Shell Programming and Scripting

How to Sort Floating Numbers Using the Sort Command?

Hi to all. I'm trying to sort this with the Unix command sort. user1:12345678:3.5:2.5:8:1:2:3 user2:12345679:4.5:3.5:8:1:3:2 user3:12345687:5.5:2.5:6:1:3:2 user4:12345670:5.5:2.5:5:3:2:1 user5:12345671:2.5:5.5:7:2:3:1 I need to get this: user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Discussion started by: daniel.gbaena
7 Replies

4. UNIX for Dummies Questions & Answers

How to insert alternative columns and sort text from first column to second?

Hi Everybody, I am just new to UNIX as well as to this forum. I have a text file with 10,000 coloumns and each coloumn contains values separated by space. I want to separate them into new coloumns..the file is something like this as ad af 1 A as ad af 1 D ... ... 1 and A are in one... (7 Replies)
Discussion started by: Unilearn
7 Replies

5. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

Hello all - I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies

6. Shell Programming and Scripting

Want to sort a file using awk & sed to get required output

Hi All, Need Suggestion, Want to sort a file using awk & sed to get required, output as below, such that each LUN shows correct WWPN and FA port Numbers correctly: Required output: 01FB 10000000c97843a2 8C 0 01FB 10000000c96fb279 9C 0 22AF 10000000c97843a2 8C 0 22AF 10000000c975adbd ... (10 Replies)
Discussion started by: aix_admin_007
10 Replies

7. Shell Programming and Scripting

Help with sort word and general numeric sort at the same time

Input file: 100%ABC2 3.44E-12 USA A2M%H02579 0E0 UK 100%ABC2 5.34E-8 UK 100%ABC2 3.25E-12 USA A2M%H02579 5E-45 UK Output file: 100%ABC2 3.44E-12 USA 100%ABC2 3.25E-12 USA 100%ABC2 5.34E-8 UK A2M%H02579 0E0 UK A2M%H02579 5E-45 UK Code try: sort -k1,1 -g -k2 -r input.txt... (2 Replies)
Discussion started by: perl_beginner
2 Replies

8. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies

9. UNIX for Dummies Questions & Answers

Best Alternative for checking input parameter contains required value or not

Any good way to check if code has the required output # /sbin/sysctl net.ipv4.icmp_echo_ignore_broadcasts net.ipv4.icmp_echo_ignore_broadcasts = 1 /sbin/sysctl net.ipv4.icmp_echo_ignore_broadcasts | grep "= 1" net.ipv4.icmp_echo_ignore_broadcasts = 1 What I can think of is above, and it... (16 Replies)
Discussion started by: alvinoo
16 Replies

10. Shell Programming and Scripting

How to Modify a file content in UNIX and sort for only required fields ?

I have the below contents in a file after making the below curl call curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "Disconnected" > test "state" : "Disconnected",, "Rno" : "5554f1d2" "state" : "Disconnected",, "Rno" : "10587563" "state" : "Disconnected",, "Rno" :... (2 Replies)
Discussion started by: Vaibhav H
2 Replies
SA(8)							      System Manager's Manual							     SA(8)

NAME
sa - summarizes accounting information SYNOPSIS
sa [ -a | --list-all-names ] [ -b | --sort-sys-user-div-calls ] [ -c | --percentages ] [ -d | --sort-avio ] [ -D | --sort-tio ] [ -f | --not-interactive ] [ -i | --dont-read-summary-files ] [ -j | --print-seconds ] [ -k | --sort-cpu-avmem ] [ -K | --sort-ksec ] [ -l | --separate-times ] [ -m | --user-summary ] [ -n | --sort-num-calls ] [ -p | --show-paging ] [ -P | --show-paging-avg ] [ -r | --reverse-sort ] [ -s | --merge ] [ -t | --print-ratio ] [ -u | --print-users ] [ -v num | --threshold num ] [ --sort-real-time ] [ --debug ] [ -V | --version ] [ -h | --help ] [ --other-usracct-file filename ] [ --ahz hz ] [ --other-savacct-file filename ] [ [ --other-acct-file ] filename ] DESCRIPTION
sa summarizes information about previously executed commands as recorded in the acct file. In addition, it condenses this data into a summary file named savacct which contains the number of times the command was called and the system resources used. The information can also be summarized on a per-user basis; sa will save this information into a file named usracct. If no arguments are specified, sa will print information about all of the commands in the acct file. If called with a file name as the last argument, sa will use that file instead of the system's default acct file. By default, sa will sort the output by sum of user and system time. If command names have unprintable characters, or are only called once, sa will sort them into a group called `***other'. If more than one sorting option is specified, the list will be sorted by the one specified last on the command line. The output fields are labeled as follows: cpu sum of system and user time in cpu minutes re "elapsed time" in minutes k cpu-time averaged core usage, in 1k units avio average number of I/O operations per execution tio total number of I/O operations k*sec cpu storage integral (kilo-core seconds) u user cpu time in cpu seconds s system time in cpu seconds Note that these column titles do not appear in the first row of the table, but after each numeric entry (as units of measurement) in every row. For example, you might see `79.29re', meaning 79.29 cpu seconds of "real time". An asterisk will appear after the name of commands that forked but didn't call exec. GNU sa takes care to implement a number of features not found in other versions. For example, most versions of sa don't pay attention to flags like `--print-seconds' and `--sort-num-calls' when printing out commands when combined with the `--user-summary' or `--print-users' flags. GNU sa pays attention to these flags if they are applicable. Also, MIPS' sa stores the average memory use as a short rather than a double, resulting in some round-off errors. GNU sa uses double the whole way through. OPTIONS
The availability of these program options depends on your operating system. In specific, the members that appear in the struct acct of your system's process accounting header file (usually acct.h ) determine which flags will be present. For example, if your system's struct acct doesn't have the `ac_mem' field, the installed version of sa will not support the `--sort-cpu-avmem', `--sort-ksec', `-k', or `-K' options. In short, all of these flags may not be available on your machine. -a, --list-all-names Force sa not to sort those command names with unprintable characters and those used only once into the ***other group. -b, --sort-sys-user-div-calls Sort the output by the sum of user and system time divided by the number of calls. -c, --percentages Print percentages of total time for the command's user, system, and real time values. -d, --sort-avio Sort the output by the average number of disk I/O operations. -D, --sort-tio Print and sort the output by the total number of disk I/O operations. -f, --not-interactive When using the `--threshold' option, assume that all answers to interactive queries will be affirmative. -i, --dont-read-summary-files Don't read the information in the system's default savacct file. -j, --print-seconds Instead of printing total minutes for each category, print seconds per call. -k, --sort-cpu-avmem Sort the output by cpu time average memory usage. -K, --sort-ksec Print and sort the output by the cpu-storage integral. -l, --separate-times Print separate columns for system and user time; usually the two are added together and listed as `cpu'. -m, --user-summary Print the number of processes and number of CPU minutes on a per-user basis. -n, --sort-num-calls Sort the output by the number of calls. This is the default sorting method. -p, --show-paging Print the number of minor and major pagefaults and swaps. -P, --show-paging-avg Print the number of minor and major pagefaults and swaps divided by the number of calls. -r, --reverse-sort Sort output items in reverse order. -s, --merge Merge the summarized accounting data into the summary files savacct and usracct. -t, --print-ratio For each entry, print the ratio of real time to the sum of system and user times. If the sum of system and user times is too small to report--the sum is zero--`*ignore*' will appear in this field. -u, --print-users For each command in the accounting file, print the userid and command name. After printing all entries, quit. *Note*: this flag supersedes all others. -v num --threshold num Print commands which were executed num times or fewer and await a reply from the terminal. If the response begins with `y', add the command to the `**junk**' group. --separate-forks It really doesn't make any sense to me that the stock version of sa separates statistics for a particular executable depending on whether or not that command forked. Therefore, GNU sa lumps this information together unless this option is specified. --ahz hz Use this flag to tell the program what AHZ should be (in hertz). This option is useful if you are trying to view an acct file created on another machine which has the same byte order and file format as your current machine, but has a different value for AHZ. --debug Print verbose internal information. -V, --version Print the version number of sa. -h, --help Prints the usage string and default locations of system files to standard output and exits. --sort-real-time Sort the output by the "real time" field. --other-usracct-file filename Write summaries by user ID to filename rather than the system's default usracct file. --other-savacct-file filename Write summaries by command name to filename rather than the system's default SAVACCT file. --other-acct-file filename Read from the file filename instead of the system's default ACCT file. FILES
acct The raw system wide process accounting file. See acct(5) for further details. savacct A summary of system process accounting sorted by command. usracct A summary of system process accounting sorted by user ID. BUGS
There is not yet a wide experience base for comparing the output of GNU sa with versions of sa in many other systems. The problem is that the data files grow big in a short time and therefore require a lot of disk space. AUTHOR
The GNU accounting utilities were written by Noel Cragg <noel@gnu.ai.mit.edu>. The man page was adapted from the accounting texinfo page by Susan Kleinmann <sgk@sgk.tiac.net>. SEE ALSO
acct(5), ac(1) 1997 August 19 SA(8)
All times are GMT -4. The time now is 02:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy