Visit The New, Modern Unix Linux Community


Curl and write custom result to file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Curl and write custom result to file
# 1  
Curl and write custom result to file

I have the following script,
Code:
for i in $(cat MyWebApps); do curl -u manager:tH1s1s4f3k3p4ssw0Rd http://10.10.10.10:7529/manager/jmxproxy/"?get=Catalina:type=Manager,context=/$i,host=localhost&att=activeSessions"; done

Which gives me an output like this
Code:
OK - Attribute get 'Catalina:type=Manager,context=/MyWebApp1,host=localhost' - activeSessions = 2
OK - Attribute get 'Catalina:type=Manager,context=/MyWebApp2,host=localhost' - activeSessions = 5
OK - Attribute get 'Catalina:type=Manager,context=/MyWebApp3,host=localhost' - activeSessions = 180
OK - Attribute get 'Catalina:type=Manager,context=/MyWebApp4,host=localhost' - activeSessions = 300
OK - Attribute get 'Catalina:type=Manager,context=/MyWebApp5,host=localhost' - activeSessions = 72
OK - Attribute get 'Catalina:type=Manager,context=/MyWebApp6,host=localhost' - activeSessions = 89

Based on the output, I need to write in a csv file as following, can you help on this?
Code:
2019-04-19-10:05,MyWebApp1,2
2019-04-19-10:05,MyWebApp2,5
2019-04-19-10:05,MyWebApp3,180
2019-04-19-10:05,MyWebApp4,300
2019-04-19-10:05,MyWebApp5,72
2019-04-19-10:05,MyWebApp6,89

INFO:
SUSE Linux Enterprise Server 11
Thank you.

Last edited by charli1; 04-19-2019 at 06:04 AM..
# 2  
Any attempts / ideas / thoughts from your side? What have you learned from your other threads, e.g. this one?


You might want to add your OS, shell, and tools' versions so people know what can be done and what to avoid.
# 3  
Thanks Rudic,
info for server added.
# 4  
Thanks for the server info. What about the other questions?
# 5  
I tryied multiple versions of the script adding awk grep etc, none worked, so i asked for help, let me know if you have any ideas,
thank yuo.
# 6  
Show your attempts and where and how they failed.
# 7  
Code:
for i in $(cat MyWebApps); do curl -u manager:tH1s1s4f3k3p4ssw0Rd http://10.10.10.10:7529/manager/jmxproxy/"?get=Catalina:type=Manager,context=/$i,host=localhost&att=activeSessions" |awk -F, '{print $6}'; done

And prints
Code:
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    97  100    97    0     0  21661      0 --:--:-- --:--:-- --:--:-- 32333
9
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    96  100    96    0     0  11370      0 --:--:-- --:--:-- --:--:-- 13714


Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #657
Difficulty: Easy
The last retail version of MS-DOS was MS-DOS 7.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Curl to download file from subdivx.com after following location without knowing the file name/extens

This question could be specific to the site subdivx.com In the past, I've been able to download a file following location using cURL but there is something about subdivx.com that's different and can't figure out how to get it to work. I tried the following directly in the terminal with no... (5 Replies)
Discussion started by: MoonD
5 Replies

2. Shell Programming and Scripting

Sort and Split file with header and custom name

Hi, I am using SUN SOLARIS (SunOS sun4v sparc SUNW, T5240). I have a huge data file with header and trailer. This file gets used into an ETL process. ETL skips the header record (which is the first record of the file) and loads the rest of the record. The file can be delimited (comma,... (5 Replies)
Discussion started by: Saanvi1
5 Replies

3. Shell Programming and Scripting

Splitting file - custom req.

Hello everybody, I have a file to split in a bit different way. My file looks like this: My_file.dat 123333333|01|38|440X|P 384747382|32|31|440X|P 320384743|32|54|420Y|I 843739349|12|43|420Y|I I need to split it into: MYFILE_440X_P.dat 123333333|01|38 384747382|32|31 ... (3 Replies)
Discussion started by: bijou
3 Replies

4. Shell Programming and Scripting

Compare 2 file and write result

Hi friends...I have 2 files, file1.txt and reference.txt I could able to find difference using diff and following command awk 'NR == FNR { A=1; next } !A' reference.txt file1.txt above command listing data which is not in reference.txt 12.12 87 11.95 88 11.83 89 12.55 84... (12 Replies)
Discussion started by: Akshay Hegde
12 Replies

5. Shell Programming and Scripting

Script to write result to a file

Hello, How can I run this script every 1 hour and save its result to result.txt ifconfig | grep 'inet addr:'| grep -v '127.0.0.1' | cut -d: -f2 | awk '{ print $1}' Regards Shaan (5 Replies)
Discussion started by: Shaan_Shaan
5 Replies

6. Shell Programming and Scripting

Populating File data with custom manipulation on file names

Hi, I am confused how to proceed firther please find the problem below: Input Files: DCIA_GEOG_DATA_OCEAN.TXT DCIA_GEOG_DATA_MCRO.TXT DCIA_GEOG_DATA_CVAS.TXT DCIA_GEOG_DATA_MCR.TXT Output File Name: MMA_RFC_GEOG_NAM_DIM_LOD.txt Sample Record(DCIA_GEOG_DATA_OCEAN.TXT):(Layout same for... (4 Replies)
Discussion started by: Arun Mishra
4 Replies

7. Shell Programming and Scripting

Write result to output file

Good morning everybody, Beeing an absolute newbie in shell scripting I would like to look for some help here. I would like to read an external text file and format the data and write it to an output file. What I was trying to do was to display the result (this worked). But now I... (1 Reply)
Discussion started by: bluejean1976
1 Replies

8. Shell Programming and Scripting

How to write result of a query to more than 1 .csv

If the result of the query is greater than say, 50,000 then the next 50,000 should be written to the second file and so on. Is it possible? (1 Reply)
Discussion started by: Jassz
1 Replies

9. Shell Programming and Scripting

script to output curl result as html

hi, new to scripting and would like to know how can I have a script which will curl a few URLs and have the results such as the URLs being curled, dns lookup time, connection time, total time, etc save in a html format in a form of table with column and rows. thank you. (4 Replies)
Discussion started by: squidusr
4 Replies

10. Shell Programming and Scripting

Outputting formatted Result log file from old 30000 lines result log<help required>

Well I have a 3000 lines result log file that contains all the machine data when it does the testing... It has 3 different section that i am intrsted in 1) starting with "20071126 11:11:11 Machine Header 1" 1000 lines... "End machine header 1" 2) starting with "20071126 12:12:12 Machine... (5 Replies)
Discussion started by: vikas.iet
5 Replies

Featured Tech Videos