I have a situation where I am writing a shell script that will accept a date value it will then pass this date value to an Oracle stored procedure for processing.
I want to format the date into (01-SEP-08) before passing to the proc. I also want to make sure the value passed in is a date value... (1 Reply)
The segment titled "Before" shows how it is now and the segment "After" (shown below) is how I want it to be sorted. Probably as a CSV format so that I can export it to a spreadsheet.
Need your help and suggestions!!
Before:
1500.100:
by the old run:
-- --- --- ----
neitqodo <... (1 Reply)
how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell.
Pls help me as its very urgent.
Thanks,
Hema. (1 Reply)
Dear Friends,
I need urgent help from u..
I have two files,file1 & file 2..
file1 have a existing data of file2.So i want to delete those existing datas from file1 (which contain the data from file1)
My file1 like this
rs39348 1 1045729 A G 0.1791 0.2054 0.84 ... (3 Replies)
I have a file in unix with sample data as follows :
--------------------------------------------------------------
--------------------------------------------------------------
{30001002|XXparameter|Layout|$
I want this file to be splitted into different files and corresponding to the sample... (54 Replies)
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
Hi,
I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates.
NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15... (2 Replies)
Hi ,
I have below data inside a file named ref.psv . I want to create a shell script which will do the below 2 points :
(1) sort the file content first based on the latest date which is the last column in the file (actual file its the 175th column)
(2)after sorting the file based on latest date... (3 Replies)
Hi,
i "tried" to sort data by date. So far, i used sed to take the data from the last and the actual month. Now, after changing the year it is not working properly.
i use:
GNU bash, version 4.2.45(1)-release (x86_64-suse-linux-gnu)
sed -n '/\//p' $Home/../scripte/pd_0.txt
y is a... (6 Replies)
Discussion started by: IMPe
6 Replies
LEARN ABOUT CENTOS
osinfo-query
OSINFO-QUERY.C(1) Virtualization Support OSINFO-QUERY.C(1)NAME
osinfo-query - Query information in the database
SYNOPSIS
osinfo-query [OPTIONS...] TYPE [CONDITION-1 [CONDITION-2 ...]]
DESCRIPTION
The "osinfo-query" command allows extraction of information from the database. TYPE can be one of "os", "platform", "device", or
"deployment". With no conditions specified, all entities of the given type will be listed.
# List all operating systems
$ osinfo-query os
Short ID | Name ...
----------------------+-----------
centos-6.0 | CentOS 6.0 ...
centos-6.1 | CentOS 6.1 ...
...
Conditions allow filtering based on specific properties of an entity. For example, to filter only distros from the Fedora Project, use
# List all operating systems
$ osinfo-query os vendor="Fedora Project"
Short ID | Name ...
----------------------+--------------
fedora1 | Fedora Core 1 ...
fedora2 | Fedora Core 2 ...
...
The set of fields which are printed can be controlled using the "--fields" command line argument:
# List all operating systems
$ osinfo-query --fields=short-id,version os vendor="Fedora Project"
Short ID | Version
----------------------+----------
fedora1 | 1
fedora2 | 2
...
OPTIONS -s PROPERTY, --sort-key PROPERTY
Set the data sorting key. Defaults sorting the first column
-f PROPERTY1,PROPERTY2,..., --fields PROPERTY1,PROPERTY2,...
Set the visibility of properties in output
PROPERTY NAMES
OS
Valid property names for the "os" type are:
short-id
The short OS identifier
name
The long OS name
version
The OS version string
family
The OS kernel family
vendor
The OS vendor
release-date
The OS release date
eol-date
The OS end-of-life date
codename
The OS code name
id The OS identifier
PLATFORM
Valid property names for the "platform" type are:
short-id
The short platform identifier
name
The long platform name
version
The platform version string
vendor
The platform vendor
release-date
The platform release date
eol-date
The platform end-of-life date
codename
The platform code name
id The platform identifier
DEVICE
Valid property names for the "device" type are:
name
The device name
product
The device product name
product-id
The device product ID string
vendor
The device vendor name
vendor-id
The device vendor ID string
class
The device type class
bus The device bus type
id The device identifier
DEPLOYMENT
Valid property names for the "deployment" type are:
id The deployment identifier
EXIT STATUS
The exit status will be 0 if matching entries were found, or 1 if not matches were found
SEE ALSO
"osinfo-db-validate(1)", "osinfo-detect(1)"
AUTHORS
Daniel P. Berrange <berrange@redhat.com>
COPYRIGHT
Copyright (C) 2012 Red Hat, Inc.
LICENSE
"osinfo-query" is distributed under the termsof the GNU LGPL v2+ license. This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE
libosinfo-0.2.7 2013-02-06 OSINFO-QUERY.C(1)