This probably isn't completely right, but it might be a start:
select node_name,hl_name,min(backup_date) from backups group by
node_name,hl_name
--
Cameron Hanover
chano...@umich.edu
Let's get dangerous.
--Darkwing Duck
On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext) bruce.k...@alcon.com wrote:
Thanks for the help!
This what I ended up with.
SELECT CAST((NODE_NAME) AS CHAR(20)) AS Node Name,CAST(MIN(BACKUP_DATE) AS
DATE) AS BACKUP DATE FROM BACKUPS WHERE NODE_NAME LIKE '%_TDP' AND
STATE='ACTIVE_VERSION' AND CLASS_NAME LIKE
'%DB%' AND BACKUP_DATE '2015-02-01' AND FILESPACE_NAME NOT
Bruce,
You could do a group by node_name at the end of your select statement.
Best Regards,
_
email: ron.delaw...@us.ibm.com
Storage Services Offerings
From: Kamp, Bruce (Ext) bruce.k...@alcon.com
To: ADSM-L@VM.MARIST.EDU
James,
What version of TSM? Your select statement will work in TSM 6.3 if
you change start_time to date_time. Please note that I did not
verify the output, only that I got output.
Rick
At 01:39 PM 6/24/2014, you wrote:
Hello Everyone -
I am attempting miserably I might add to write a select
Version 7.1
James Lepre
Infrastructure Support Specialist
Solix, Inc. | 30 Lanidex Plaza West | Parsippany, NJ 07054
T: 973.581.5362 | F: 973.599.6544
www.solixinc.com | Solix on Facebook | Solix on Twitter
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU]
SELECT * FROM ACTLOG WHERE MSGNO IN (406,4952,4954,4958,4960,4957,
4970,4959,4961,4965,4963,4966,4967,4968,4969,4964, 4976, 4981) and
start_timecurrent_timestamp - 24 hours
On 24 June 2014 19:39, Lepre, James james.le...@solixinc.com wrote:
Hello Everyone -
I am attempting miserably I might
] Subject
.EDU Re: select statement: help!
01/18/2005 12:42
PM
Please respond to
ADSM: Dist Stor
Manager
[EMAIL PROTECTED]
.EDU
, 19 January, 2005 14:00
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select statement: help!
Hey!
I have one other simple question. Is there a way that the output of
this select statement will be able to go on one line so that it isn't so
hard to read? The output currently looks like this, but I would
On Jan 19, 2005, at 8:00 AM, Joni Moyer wrote:
I have one other simple question. Is there a way that the output of
this
select statement will be able to go on one line ...
See my notes in http://people.bu.edu/rbs/ADSM.QuickFacts topic SELECT
output, columnar instead of keyword list.
Richard
:cc
Dist Stor
Manager Subject
[EMAIL PROTECTED] Re: select statement: help!
.EDU
01/19/2005 08:16
AM
Please respond to
ADSM: Dist Stor
HMARK.COM cc: (bcc: Eivind Birkeland)
Sent by: ADSM:Subject: Re: select statement:
help!
Dist Stor
Manager
[EMAIL PROTECTED]
ST.EDU
: Wednesday, 19 January, 2005 14:55
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select statement: help!
Hello,
I went out and tried the following:
dsmadmc -servername=server -displaymode=table select statement and it
didn't work. Do you have to put the statement within single quotes?
Thanks
ADSM-L@VM.MARIST.EDU
Sent by: ADSM: cc
Dist Stor
Manager Subject
[EMAIL PROTECTED] Re: select statement: help!
.EDU
01/19/2005 08:16
AM
Please respond to
ADSM
cc
Manager
[EMAIL PROTECTED] Subject
.EDU Re: select statement: help!
01/19/2005 11:34
AM
Please respond to
ADSM
Joni - Match your quotes and you'll quickly see what's wrong.
Richard Sims
On Jan 19, 2005, at 12:31 PM, Joni Moyer wrote:
Hi Andy!
You have a very good point of showing my command. Without it is kind
of
difficult. Here is the exact command that I am entering (I'm just
going to
use admin
: cc
Dist Stor
Manager Subject
[EMAIL PROTECTED] Re: select statement: help!
.EDU
01/19/2005 08:16
AM
Please respond to
ADSM: Dist Stor
Manager
Maybe something like:
select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, time(start_time) as start, time(end_time) as
end, -
cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
decimal(7,0)) as files, successful -
from
Stor Manager [EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Subject
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only exists
in a storage pool when it contains client data (and is therefore no
longer a scratch tape).
--
Mark
PROTECTED]
23/11/2004 07:23 AM
Please respond to
ADSM: Dist Stor Manager [EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Subject
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only exists
in a storage pool when it contains client data
PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
23/11/2004 07:23 AM
Please respond to
ADSM: Dist Stor Manager [EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Subject
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only
On Nov 30, 2004, at 8:40 AM, James Choate wrote:
The scratch column is case sensitive. Looks like the yes no are
capitalized.
The status column is YES|NO|NULL
Such things are prone to change over time: in some releases only
the initial character is capitalized. We often have to find out
the
The use of upper/lower functions in SQL statements can save a lot of
grief!
[EMAIL PROTECTED] 11/30/2004 8:47:29 AM
On Nov 30, 2004, at 8:40 AM, James Choate wrote:
The scratch column is case sensitive. Looks like the yes no are
capitalized.
The status column is YES|NO|NULL
Such things
There are no scratch tapes in storage pools. A tape volume only exists
in a storage pool when it contains client data (and is therefore no
longer a scratch tape).
--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627
-Original Message-
From: ADSM: Dist
There are no scratch tapes in storage pools. A tape volume only exists
in a storage pool when it contains client data (and is therefore no
longer a scratch tape).
Just a footnote on this: Though less commonly seen, an empty tape volume
can also exist in a storage pool if it is manually defined
?
Doesnt the customers filespace containt the nodename(servername)?
If not, a q filespace should show you which filespace that belongs to
which node.
Best Regards
Daniel Sparrman
---
Daniel Sparrman
Chef Utveckling Drift
Exist i Stockholm AB
Propellervägen 6B
select node_name from occupancy where filespace_name='/cagvsp1/entp/prod'
[EMAIL PROTECTED]
Cain, Jason (Corporate) [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
10/07/2004 09:32 AM
Please respond to
ADSM: Dist Stor Manager [EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Ben Bullock wrote :-
Ok, this should be simple, but it's driving me nuts.
Ben,
Try this one ... (caters for mulitple libraries)
* */
/* Script Name: Q_STORAGE_UTIL */
/* Description: Display utilisation of all */
/*
:09 AM
To: [EMAIL PROTECTED]
Subject: Re: Select statement help.
Ben Bullock wrote :-
Ok, this should be simple, but it's driving me nuts.
Ben,
Try this one ... (caters for mulitple libraries)
* */
/* Script Name: Q_STORAGE_UTIL
I took your code and added a max function.
Not sure if this is the best SQL way to deal with it but it makes the group
by happy and seems to work:
select max(st.STGPOOL_NAME) as STGPOOL, max(st.maxscratch) as
MAXSCRATCH, (count(vo.VOLUME_NAME))as # of tapes from volumes vo,
stgpools st where
I am in need of some help here I have been asked to come up a way to do a
select to find active and inactive file dates on files. Help would be
appreciated very much.
The following should help you in general:
TSM Technical Guide redbook, appendix A TSM SQL.
Sample SQL Select
]
To:[EMAIL PROTECTED]
cc:
Subject:Re: select statement help
I am in need of some help here I have been asked to come up a way to do a
select to find active and inactive file dates on files. Help would be
appreciated very much.
The following should help you in general:
TSM Technical
select message from actlog where msgno=0986 and
date_time(current_timestamp-(1 hour))
Michael French
Savvis Communications
Enterprise Storage Engineer
(314)628-7392 -- desk
(408)239-9913 -- mobile
-Original Message-
From: Chang, Calvin [mailto:[EMAIL PROTECTED]
Sent: Thursday, May
32 matches
Mail list logo
