Date is retrieved from SQL it is in this format YYYY-MM-DD HH24MI i.e 2019-12-12 0001 and is having data for 1 hour i.e 2019-12-12 0001 to 2019-12-12 0060
the whole output of the query consists of 3 columns date_time calling_app and count of requests
SQL script output is like given below
Code:
Date_time Calling_app Count
2019-12-12 0000 X 12
2019-12-12 0001 y 3
2019-12-12 0002 c 4
2019-12-12 0003 v 6
2019-12-12 0004 a 8
2019-12-12 0005 q 7
Want output like this, Also please note that there can be entries in between the timestamps for other applications as well
Code:
Date_time x y c v a q
2019-12-12 0000 12
2019-12-12 0001 3
2019-12-12 0002 4
2019-12-12 0003 6
2019-12-12 0004 8
2019-12-12 0005 7
Also pleas let me know if any more inputs or data is required from my end.
Thanks,
TNT47
Moderator's Comments:
Please do wrap your samples/codes in your posts in CODE TAGS as per forum rules.
Last edited by RavinderSingh13; 12-16-2019 at 01:31 AM..
Hi,
I want to compare two files. Files will look like as follows:
file1:
ASDFGHJU|1234567890123456
QWERTYUI|3456789098900890
file2:
ZXCVBVNM|0987654321234567
POLKIJUYH|1234789060985478
output file should be:
ASDFGHJU|1234567890123456
QWERTYUI|3456789098900890
Thnaks in advance (6 Replies)
Hi all,
I need to create a matrix of variable rows and columns. Right now i have 3 rows and two columns and following values.
Output something like
TypeA TypeB
TestCase1 Pass Fail
TestCase2 Pass ... (2 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi ,
This is my first thread ; facing some issues withmy sed script
I need to insert the code from my log file which is between two keywords.
content is like this ........
log
############################
log1 log2
231 "Ban" "tom" and the line one of the cross line
friend... (2 Replies)
Hi all,
I am beginner in UNIX...I want to use unix shell script to create text.file...I know how to use using by command...can anybody tell me for the script?
Thanks
i changed the threads title from "tex file" to "text file", because "tex" would probably be misunderstood as reference to... (4 Replies)
Hi ,
I am having two files like this
FILE1
####################
input SI_TESTONLY_R_00;
input CE0_SE_INPUT_TESTONLY;
input CE0_TCLK_TESTONLY;
input SI_JTGCLOCKDR_JTAG_R_00;
input CE0_TCLK_JTGCLOCKDR_JTAG;
input CE0_SE_INPUT_JTGCLOCKDR_JTAG;
output SO_TESTONLY_R_00;
output... (2 Replies)
Hi Team,
Could you please help me on below query:
I want to retrieve XML elements from one .xml file. This .xml file has commented tags as well. so i am planning to write Unix command/script which 1.will chekc for this .xml file
2. it will ignore the commented XML lines. i.e. XML tags between... (3 Replies)
Hi folks,
I am new for shell script, I hope somebody to help me to write shell script
My requirement is below steps
1. I have apache access.log i.e located in /var/log/httpd/
Ex.
127.0.0.1 - - "GET... (14 Replies)
I have a large semicolon delimited file with thousands of columns and many thousands of line. It looks like:
ID1;ID2;ID3;ID4;A_1;B_1;C_1;A_2;B_2;C_2;A_3;B_3;C_3
AA;ax;ay;az;01;02;03;04;05;06;07;08;09
BB;bx;by;bz;03;05;33;44;15;26;27;08;09
I want to split this table in to multiple files:
... (1 Reply)
Discussion started by: trymega
1 Replies
LEARN ABOUT MOJAVE
xscertadmin
xscertadmin(8) BSD System Manager's Manual xscertadmin(8)NAME
xscertadmin -- process Certificate Revocation Lists in an OD environment
SYNOPSIS
xscertadmin command [common options] [command options]
DESCRIPTION
Manage Certificate Revocation Lists (CRLs) in an Open Directory Environment.
COMMANDS
list [-x] [-v] [-d <debug_level>] [-a | <issuer_common_name>]
add [-x] [-v] [-d <debug_level>] [-r <reason_code>] [-t <type>] <user/record name>
add [-x] [-v] [-d <debug_level>] [-r <reason_code>] [-t <type>] -f <file_of_names>
add [-x] [-v] [-d <debug_level>] [-r <reason_code>] -i <issuer_common_name> -s <serial_number>
COMMON OPTIONS
-x/--xml Returns output to stdout in xml format.
-v/--version Print the version of the tool.
-d/--debug <debug_level>
Sets the level of diagnostic message detail, 0 for off and 1 for on.
LIST OPTIONS
-a/--all List all CRLs
ADD OPTIONS
-f/--file A file containing names.
-i/--issuer The common name of the issuer of the certificate.
-r/--reason The revocation reason code.
-s/--serial The serial number of the certificate to revoke.
-t/--type The record type: user, device, computer or recordType.
REASON CODES
0 unspecified
1 keyCompromise
2 cACompromise
3 affiliationChanged
4 superseded
5 cessationOfOperation
6 certificateHold
9 privilegeWithdrawn
10 aACompromise
MacOSX June 1, 2019 MacOSX
12-16-2019
