Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Completey new to scripting, question/help?
Top Forums Shell Programming and Scripting Completey new to scripting, question/help? Post 302945394 by xdawg on Friday 29th of May 2015 02:24:14 PM
Old 05-29-2015
Awesome, that worked perfectly.

Many thanks again to both Don and Rudi!

---------- Post updated 05-29-15 at 11:24 AM ---------- Previous update was 05-28-15 at 08:06 PM ----------

Ok, so I'm back, the CEO has changed how he wants the output sorted/presented.

He wants it primarily sorted alphanumerically by organization which is the second part of the username after the "@".

Then the secondary sort key would be increasing date. And finally a third sort key would be alphanumeric using just the user without the org part.

So thinking it through, if I were to use Don your last piece of code:

Code:
awk '
match($0, /"username":"[^"]*"/) {
        split($3, d, "@")
        user = substr($0, RSTART + 12, RLENGTH - 13)
        c[d[1] "," user]++
}
END {   for(i in c)
                printf("%d,%s\n", c[i], i)
}'      liquidgrids.log | sort -t, -k3,3 -k2,2

And here is a sample entry again:

Code:
qtp111659197-5776 - 05-26@09:37:34:240 INFO  (TimingInfoProxy.java:41)     - com.mycompany.api.ApiHandler-0>getUniqueDataBySource(data,{"has_values":false,"last_event_triggered":"","user_info":{"username":"joe@mycompany.com","orgid":"69d467a7-9786-47e1-9c12-bb40f9bfc65d","ip":"127.0.0.1"},"date_range":{"min_date":"","start_date":"","end_date":"","trending_start_date":"","trending_end_date":""},"terms":{"and_filtering":[]}},)

We would have to split the user key into two pieces, user (in this example joe) and org (in this example mycompany without the .com)? And then change the sort order of the keys at the end of the script? Or would this require a second script?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

another scripting question

I am writing a script that will identify the oldest file in a directory. Here's the syntax: #!/bin/ksh cd directory chmod 777 * ls -r -1t > file1 sed -n -e "1P" < file1 > file2 So my problem is, now I have file2, which contains the name of the oldest file in the directory. How do I use,... (1 Reply)
Discussion started by: kristy
1 Replies

2. Shell Programming and Scripting

Scripting Question

This script searches for core files and if it finds one, it emails me to let me know.I DONT want it to email me if it doesn't find one but I can't figure out what I need to change or add. Any thoughts? Script below: /bin/find / -name core -type f -ls -exec file {} \;|/usr/bin/mailx -s... (1 Reply)
Discussion started by: damielle
1 Replies

3. Shell Programming and Scripting

another scripting question

Hello I am working on cleaning up permissions on Oracle mountpoints and datafiles in unix. I am looking for a script or a scripting idea to 1st. 1. grep for owner oracle 2. ensure its a directory owned for oracle 3. chmod 750 on the oracle owned directory. 4. grep for oracle files, etc... (3 Replies)
Discussion started by: jigarlakhani
3 Replies

4. Shell Programming and Scripting

scripting question

I'm new to shell scripting and am having a problem trying to do something in C shell. I want to write a script that will input something instead of a user doing it. For example, using the command 'write' the user is supposed to type something to be sent to another user. I want a script to be able... (3 Replies)
Discussion started by: batmike
3 Replies

5. Shell Programming and Scripting

scripting question?

I am writing a backup script for AIX 5 and running into a problem where the output isn't being shown in the output log that is being created. Any ideas on how this would be corrected? I have included the script below. The only thing showing up in the file is listed below. I was hoping to capture... (2 Replies)
Discussion started by: justinburbridge
2 Replies

6. Solaris

Scripting question

I'm writing a small script that will run an executable program (sort of like TOP). To exit the executable, you have to enter control C (^c). I'm trying to use a redirect input file to send the ^c but I'm not having any luck. My short script looks like this - /mydirectory/abc.script < abc.in >... (1 Reply)
Discussion started by: gonzotonka
1 Replies

7. Shell Programming and Scripting

Scripting question

Folks; I'm writing a shell script to extract some fields out of a log file & it will run periodically, how can i make it runs starting from where it left of. for example; if the script will do the extract every 2 days, let's say the first run will extract fields until July 25, 2007 @ 11:15:22... (1 Reply)
Discussion started by: moe2266
1 Replies

8. UNIX for Dummies Questions & Answers

Scripting question

folks; I have a script to remove any files that older than 14 days then move any files that younger than 7 days to another directory. but for some reason it doesn't move the files, when i do it manually it works but not through the script. i tried 2 different ways in writing the move part but it... (6 Replies)
Discussion started by: Katkota
6 Replies

9. Shell Programming and Scripting

Scripting question

Preview of command prompt f ---> to start ferret q----> to stop ferret asp@nex:~$ f NOAA/PMEL TMAP FERRET v6.82 Linux 2.6.18-308.8.2.el5PAE 32-bit - 08/03/12 3-Dec-12 16:44 yes? go my.jnl yes?column=4/skip=1/type=num,text ............filename.txt ---... (4 Replies)
Discussion started by: nex_asp
4 Replies

10. Shell Programming and Scripting

Scripting question

hi all, I am writing a script and beginner in shell scripting. I have tried the below script. could you please check and let me know whether the below scirpt is correct. Unix details : HP Unix Input file. cat input.txt | tail -4 HTS40002.W1978.PROM HTS40003.W1978.PROM... (17 Replies)
Discussion started by: arun888
17 Replies

LEARN ABOUT OPENDARWIN

sa1

sa1(8)							    BSD System Manager's Manual 						    sa1(8)

NAME

     sa1 -- Generate a system activity daily data file.

SYNOPSIS

     /usr/lib/sa/sa1 [t n]

DESCRIPTION

     The sa1 command is a shell script used to invoke the system activity data collector, sadc.  The binary sample data is collected at intervals
     t seconds apart, in a loop n times.  The binary sample data is written to the standard daily data file, /var/log/sa/sadd where the dd repre-
     sents the current day of the month.

     sa1 is intended to be started by cron.

EXAMPLE CRON ENTRY

     # Starting at 8am collect system activity records
     # every 20 minutes for 12 hours
     # 20 minutes = 1200 seconds
     # 12 hours with 3 samples each hour = 36 loops

     0 8 * * 1-5 /usr/lib/sa/sa1 1200 36

     # After the 12 hour period,
     # collect a system activity report

     30 20 * * 1-5 /usr/lib/sa/sa2 -A

FILES

     /var/log/sa/sadd  Default daily activity file that holds the binary sampling data.  dd are digits that represent the day of the month.

SEE ALSO

     sa2(8), sadc(8), sar(1), iostat(8), vm_stat(1), netstat(1), top(1), sc_usage(1), fs_usage(1), crontab(1), crontab(5)

Mac OS X							    Jul 25 2003 							  Mac OS X
All times are GMT -4. The time now is 09:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy