Dear Team,
I am try n gerrating a report by writing a shell script, the content of the report should be aggrigated based on date value exist in the content of the file. initially the file is zip format
My file content is in below format
File contains the date in the data of 2nd column, report should aggrigate data based on call date in 2nd column, e.g calls for 20130506 should come in one row and calls for 201307 should come in 2nd row. This call_date and values in the file should have a specific index location in the file. As our call date starts from 43 and is length 8
Only requirement is to find out such call_date from the file calculate number of call as above script is calculating.
The report output in report would be like
data1 data2 data3 call_date1 data4
data1 data2 data3 call_date2 data4
Kindly suggest.
Last edited by balram0179; 05-31-2013 at 07:28 AM..
Hi
Please help me to resolve the below query.
My shell script has generated a file output.file like below
********************************
DROP TABLE GPS_CONTACT_DETAILS
DB20000I The SQL command completed successfully.
CREATE TABLE GPS_CONTACT_DETAILS ( CONTACT_ID ... (8 Replies)
Hi All,
I am trying to generate quarter dates with user giving input as begin date and end date. Example: Input by user:
begin_date = "2009-01-01"
end_date = 2010-04-30"
required output:
2009-01-01 2009-03-31 09Q01
2009-04-01 2009-06-30 09Q02
.
.
till
2010-01-01 2010-03-31 10Q01
... (9 Replies)
Hi, I need to generate graph from the text file in Unix server.
The file contains the following data,
Fri Feb 03 07:01:00 PST 2012|3325
Fri Feb 03 07:02:00 PST 2012|3349
Fri Feb 03 07:03:00 PST 2012|3290
Fri Feb 03 07:04:00 PST 2012|3496
Fri Feb 03 07:05:00 PST 2012|3362
Fri Feb 03 07:06:00... (2 Replies)
Hi All,
We have one client.for this client some jobs got scheduled. Those jobs will run daily/weekly/Monthly. But once it runs it will generate some log files with date and Timestamp. In log folder it contains the complete logs of that particular job.
By end of every month we are going to take... (0 Replies)
Hello Gurus
Is anyone aware of a script/utility that can be used to generate a report from a combined "sudoers" file for more than 100 servers in one go please?
Basic query: Which particular user or an user group can execute root equivalent commands or has the ability for e.g. to do a... (1 Reply)
Hi All.
This my first post to this forum, and i assuming it will be best out-of all.
I am quite new to Unix scripting so please excuse me for any silly questions -
I am trying to create on Unix script in which it telnet to my server, check the connectivity of the server and then it... (2 Replies)
I have 3 user in my linux machine let's say a,b,c .By Using last command I am able to identify list of last logged in user and by w command who is logged in and what they are doing and by history command all command used by particular user all will be shown.
Now I want to write shell script... (1 Reply)
Appreciate help for the below issue.
Im using below code.....I dont want to attach the logs when I ran the perl twice...I just want to take backup with today date and generate new logs...What I need to do for the below scirpt..............
1)if logs exist it should move the logs with extention... (1 Reply)
I am trying to work on a script where it is a *(star) delimited file has a multiple lines starts with RTG and 3rd column=TD8 I want to substring the date part and
I want to replace with currentdate minus 15 days. Here is an example. iam using AIX server
$ cat temp.txt
RTG*888*TD8*20180201~... (1 Reply)
Discussion started by: Shankar455
1 Replies
LEARN ABOUT SUSE
mysqlbug
MYSQLBUG(1) MySQL Database System MYSQLBUG(1)NAME
mysqlbug - generate bug report
SYNOPSIS
mysqlbug
DESCRIPTION
This program enables you to generate a bug report and send it to Oracle Corporation. It is a shell script and runs on Unix.
The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. This database is public and
can be browsed and searched by anyone. If you log in to the system, you can enter new reports. If you have no Web access, you can generate
a bug report by using the mysqlbug script.
mysqlbug helps you generate a report by determining much of the following information automatically, but if something important is missing,
please include it with your message. mysqlbug can be found in the scripts directory (source distribution) and in the bin directory under
your MySQL installation directory (binary distribution).
Invoke mysqlbug without arguments:
shell> mysqlbug
The script will place you in an editor with a copy of the report to be sent. Edit the lines near the beginning that indicate the nature of
the problem. Then write the file to save your changes, quit the editor, and mysqlbug will send the report by email.
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQLBUG(1)