Report with mutiple files.


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Report with mutiple files.
# 1  
Data Report with mutiple files.

Hi all,
In the process of creating CPU reports.
I've already used `sar` to create a daily file, then monthly reports for CPU usage (which is averaged across all 4 CPU's).
I've now used `cpusar -P ?`(?=CPU#) to collect individual CPU data and have four files for each day which is great.

The problem I'm trying to work out is how to script the loops to get what details I need.
The filename for the daily cpusar files are like the following...
-r--r--r-- 1 operator group 4123 Jan 22 23:55 cpu022.1
-r--r--r-- 1 operator group 4123 Jan 22 23:55 cpu022.2
-r--r--r-- 1 operator group 4123 Jan 22 23:55 cpu022.3
-r--r--r-- 1 operator group 4123 Jan 22 23:55 cpu022.4
-r--r--r-- 1 operator group 4123 Jan 23 23:55 cpu023.1
-r--r--r-- 1 operator group 4123 Jan 23 23:55 cpu023.2
-r--r--r-- 1 operator group 4123 Jan 23 23:55 cpu023.3
-r--r--r-- 1 operator group 4123 Jan 23 23:55 cpu023.4
-r--r--r-- 1 operator group 4123 Jan 24 23:55 cpu024.1
-r--r--r-- 1 operator group 4123 Jan 24 23:55 cpu024.2
-r--r--r-- 1 operator group 4123 Jan 24 23:55 cpu024.3
-r--r--r-- 1 operator group 4123 Jan 24 23:55 cpu024.4

The file name is made up with the Julian date and the CPU#.

I'm wanting to create a report similar to the following, cycling backwards 30 days from the current Julian date.
Code:
       ---- CPU #1 ----  ---- CPU #2 ----  ---- CPU #3 ----  ---- CPU #4 ----
Date   Avg Pek Pek-Time  Avg Pek Pek-Time  Avg Pek Pek-Time  Avg Pek Pek-Time  
01/01  000 000 00:00:00  000 000 00:00:00  000 000 00:00:00  000 000 00:00:00

Any suggestions? I've really only got basic scripting skills presently and know little(if any) `awk` or `perl`.

Last edited by Cameron; 01-24-2002 at 03:40 PM..
# 2  
Re: Report with mutiple files.

Cameron,

Will you please send/show the content of any of
the files you are creating ?
It will help to work out the solution.

J1yant
# 3  
J1yant,

Thanks for the reply, but if you have `sar` or `cpusar` then you'll already have an understanding of the output. Fortunately the content is not relavent as I'm wishing to acquire the necessary looping logic to then retrieve the details.

Cheers,
Cameron
# 4  
OK, so you have limited scripting skills.

Here's an easy suggestion which won't tax them.

This only works by groups of the same month, which is what I'm assuming you want to do.

1) ls -lt will list files in time stamp order

2) grep will pick out certain months for you

3) cat those files into your report

e.g.

ls -lt *[filenames] | grep Jan | awk '{ print $9 }' > temp

produces a list files from January


edit temp to look like

cat [file1] > report
cat [file2] >> report
cat [file3] >> report
cat etc.

then simply source temp


Ok there are far more suffisticated ways to do it, but this way just uses ls & grep ( oh and maybe awk)
# 5  
AreaMan,

Thanks for your reply, but it's far from what I was requiring.
You may not have read my previous posting correctly.
Where in earth was I going to use `s -lt *[filenames] | grep Jan | awk '{ print $9 }' > temp ` when I'm using Julian dates to form the filenames.

Sorry, my scripting skills are a bit sharper than that.
As I said before - looping logic.
I've got 4 files for each day that I need to loop through, get stats and report.
Login or Register for Dates, Times and to Reply

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

Test Your Knowledge in Computers #747
Difficulty: Medium
The Z80 uses 248 out of the available 256 codes as single byte opcodes.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split large xml into mutiple files and with header and footer in file

Split large xml into mutiple files and with header and footer in file tried below it splits unevenly and also i need help in adding header and footer command : csplit -s -k -f my_XML_split.xml extrfile.xml "/<Document>/" {1} sample xml <?xml version="1.0" encoding="UTF-8"?><Recipient>... (36 Replies)
Discussion started by: karthik
36 Replies

2. Shell Programming and Scripting

paste mutiple files in a loop

file1.txt file2.txt file3.txt desired output is each file is in the same directory, hasthe same number of columns but different rows. i want to be able to paste them into one file. thanks! (5 Replies)
Discussion started by: johnkim0806
5 Replies

3. Shell Programming and Scripting

how to replace words in mutiple files under the same directory

I would like to get help to find how to replace word in files from command line instead of to vi to each file. This is the command i am running now. grep <old word> * vi (file with the word found in it) 1,$s/<old word>/<new word>/g It would very helpful if I can combine these in one... (2 Replies)
Discussion started by: ywu081006
2 Replies

4. UNIX for Advanced & Expert Users

Remove first line from mutiple files

How to remove the first line from multiple files and use it as source to the jobs. Only at the runtime it should remove the first line not in the file . (1 Reply)
Discussion started by: etldeveloper
1 Replies

5. Shell Programming and Scripting

Renaming mutiple files with hyphens in name

I have searched throught a host of threads to figure out how to rename mutiple files at once using a script. I need to convert 200+ files from: fKITLS_120605-0002-00001-000001.hdr to eStroop_001.hdr fKITLS_120605-0002-00002-000002.hdr to eStroop_002.hdr and so forth.... What is... (5 Replies)
Discussion started by: akenne3
5 Replies

6. UNIX for Dummies Questions & Answers

copy mutilple files to mutiple folders

Hi, I just started to learn shell progamming and just can't get my head around the following problem. I need to do the following: I have a folder which contains 100+ subfolders. Inside these subfolders there is one folder named 'Morph' and several jpg's. I need to copy all the files into... (4 Replies)
Discussion started by: M474746
4 Replies

7. IP Networking

Mutiple nics on Freebsd 7.0

I had the pleasure of having a gig nic given to me this week, which also appears on the hardware list of FreeBSD. What I would LIKE to do is: 1). Set my 10/100 nick as the dedicated outside/internet connection with a lan ip of 192.168.1.100 2). Set the gig nick as the dedicated... (2 Replies)
Discussion started by: droolin
2 Replies

8. Shell Programming and Scripting

Mutiple For loops - moving files to another directory

I need to clean out some application subdirectories from backup scripts we used to rename to various backup extensions just in case the script failed in production and we need to rollback. I will be moving these old scripts to a staging directory and then removing them after 30 days (I have the... (9 Replies)
Discussion started by: tekster757
9 Replies

9. Shell Programming and Scripting

Sending mutiple files thru email to lotus notes

Hi All, I am currently using the following script to send the single file to one/more email addresses. I need to send mutilple files at same time, are there anyway I could modify the script or write new one to accomplish the same. Script *************** #!/bin/ksh # Author: Manish... (4 Replies)
Discussion started by: lapisguy
4 Replies

10. Shell Programming and Scripting

removing mutiple files

I have a script which removes files (if they exist) Here is a cut down example of the script. Variables file1,file2 etc have already been initialized #!/bin/bash if then \rm file1 fi if then \rm file2 fi if then \rm file3 fi if then \rm file4 (9 Replies)
Discussion started by: run_time_error
9 Replies

Featured Tech Videos