01-05-2005
help with awk to create report
Hi,
I am trying to create a report using the following syntax:
#!/bin/awk -f
#script name: users_report
BEGIN { FS=":" ; OFS="\t" ; print "User\tGID\tUser Name\tHome Dir\t"
{ print $1 , $3 , $5 , $6 }
END { print "\n End of Report \n" }
$> user_report /etc/passwd
the output of above code is as under:
User GID User Name Home Dir
jbond 500 James Bond /home/sales
pdavid 501 Pierre Davidd /home/Marketing
... so on
END of Report
now trying to change the GID number to group name from /etc/group first filed.
the output should look like this:
User GID User Name Home Dir
jbond SALES James Bond /home/sales
pdavid Market Pierre Davidd /home/Market
... so on
END of Report
Can someone help me complet this code with awk or with any other appropriate command syntax please.
Thanks in advance for your help.
Regards,
Ghazi
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi
suppose I want to create a report where it will shows the machine name, the date & time when the report is produced.
can anyone please help me to write such shell script?
requesting all.
Thanks (10 Replies)
Discussion started by: moco
10 Replies
2. Shell Programming and Scripting
What i'm trying to do is to use grep to search through a few files for a selected daemon and only report on today's date.
I think I got it sorted apart from in the txt file the date has 2 gaps between the month and the day, and the way I have the date format only puts in one gap any help to get... (3 Replies)
Discussion started by: MBN
3 Replies
3. Shell Programming and Scripting
Dear Unix champs,
I have a input file as attached, i would like to create an report from the file as below
FileType | EQUENS0001 | EQUENS0002 | EQUENS1100 | EQUENS0003
--------+--------------------------------------------------------
Msg No |... (3 Replies)
Discussion started by: manas_ranjan
3 Replies
4. Shell Programming and Scripting
Greetings.
I need to generate a simple report via Bash (Korn?) with this raw data
Test_Version=V2.5.2
Test_Version=V2.6.3
Test_Version=V2.4.7
Test_Version=V2.5.2
Test_Version=V2.5.2
Test_Version=V2.5.1
Test_Version=V2.5.0
Test_Version=V2.3.9
... (3 Replies)
Discussion started by: alan
3 Replies
5. Shell Programming and Scripting
I am currently trying to develop a script to connect to mulltiple servers, reading specifc data from log files on the servers and append the data from each file into a single tab delimited row. So, at the end I am planning to have a report with all the extracted data with each row per server. I am... (5 Replies)
Discussion started by: scriptingnewbie
5 Replies
6. Shell Programming and Scripting
Hi,
I am an amateur bash scriptwriter and I need to write a script which creates a report in a formatted, easy to read table-like that is displayed to standard output. The script has to export the followings: Process ID,User Name, Command Name,Priority.....
Now I have a file that I can see all... (3 Replies)
Discussion started by: bashily
3 Replies
7. Shell Programming and Scripting
Hi,
In our company, we have been asked to design a script to automate the report of all IP's which are free/used from all the pools in DHCP at any given Amount of time. We have prepare the following script. The problem is when we run the script manually from the command prompt, it brings proper... (1 Reply)
Discussion started by: Crazy_Nix
1 Replies
8. Shell Programming and Scripting
I have created one file that contains all the necessary info in it to create a download link. In each of the lines /results/analysis/output/Home/Auto_user_S5-00580-6-Medexome_67_032/plugin_out/FileExporter_out.67... (8 Replies)
Discussion started by: cmccabe
8 Replies
9. Shell Programming and Scripting
Input file will be
Name: serve1
has disk :Yes
dev (8):
Name: serve2
has disk :No
dev (8):
Name: serve3
has disk :No
Name: serve4
has disk :Yes
dev (8):
Need output like that. I was using pate -d, - - - . But that need all the line in same format in this some server it has... (4 Replies)
Discussion started by: ranjancom2000
4 Replies
END(7) PostgreSQL 9.2.7 Documentation END(7)
NAME
END - commit the current transaction
SYNOPSIS
END [ WORK | TRANSACTION ]
DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT(7).
PARAMETERS
WORK, TRANSACTION
Optional key words. They have no effect.
NOTES
Use ROLLBACK(7) to abort a transaction.
Issuing END when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To commit the current transaction and make all changes permanent:
END;
COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT(7), which is specified in the SQL standard.
SEE ALSO
BEGIN(7), COMMIT(7), ROLLBACK(7)
PostgreSQL 9.2.7 2014-02-17 END(7)