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 N
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) wrote:
> I am found a co
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)"
To: ADSM-L@VM.MARIST.EDU
Date: 03/09/15 12:46
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_time>current_timestamp - 24 hours
On 24 June 2014 19:39, Lepre, James 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] On
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 sele
**
>
>
>
> "Andrew Raibeck"
> <[EMAIL PROTECTED]
> OM> To
> Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
> Dist Stor cc
> Manager"
> <[EMAIL PROTE
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 admin
To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU>
AC Brion
> Arnaud"
> <[EMAIL PROTECTED] To
> ALPINA.COM> ADSM-L@VM.MARIST.EDU
> Sent by: "ADSM: cc
> Dist Stor
> Manager" Subject
> <[EMAIL PROTECTE
mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: 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 h
<[EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU
HMARK.COM> cc: (bcc: Eivind Birkeland)
Sent by: "ADSM:Subject: Re: select statement:
help!
Dist Stor
Sent by: "ADSM:cc
Dist Stor
Manager" Subject
<[EMAIL PROTECTED] Re: select statement: help!
.EDU>
01/19/2005 08:16
AM
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 S
, 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
<[EMAIL PROTECTED] Subject
.EDU> Re: select statement: help!
01/18/2005 12:42
PM
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 summ
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
Su
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 par
> Matt Chan
>
>
> "Stapleton, Mark" <[EMAIL 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
> [EMA
: "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
/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
> 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 defin
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
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 PROTE
?
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 6
: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
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 */
/*
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
tor Manager" <[EMAIL PROTECTED]>
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
>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 Selec
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 20
32 matches
Mail list logo
