h 10, 2015 11:05 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement Help
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 da
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
9/15 12:46
Subject: [ADSM-L] Select Statement Help
Sent by:"ADSM: Dist Stor Manager"
I am found a couple TDP SQL nodes that aren't inactivating there backups
so TSM isn't expiring them...
What I am trying to find is the oldest backup date for each server wit
I am found a couple TDP SQL nodes that aren't inactivating there backups so TSM
isn't expiring them...
What I am trying to find is the oldest backup date for each server with a name
like _TDP.
I can get this:
Node Name HL_NAME
B
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
] On Behalf Of Rick
Saylor
Sent: Tuesday, June 24, 2014 3:19 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement Help
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 ver
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
Hello Everyone -
I am attempting miserably I might add to write a select statement that will
produce a bunch of message found in the actlog. The problem I am having is
grabbing the data from the last 24 hours.. I will schedule this to produce an
email each day.. Any thoughts on how to constru
**
>
>
>
> "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
Hello All!
I have been trying, what seems like forever, to get this select statement
to work and I am just not sure what I am doing wrong... Any suggestions? I
am trying to get a list of the backups of all of the servers that begin
with hm* and geo* within the past 24 hours and if they were succe
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
[mailto:[EMAIL PROTECTED] On
> >Behalf Of Nancy L Backhaus
> >Sent: Monday, November 22, 2004 12:59 PM
> >To: [EMAIL PROTECTED]
> >Subject: Select Statement Help for Volume Breakdown
> >
> >How do I combine these two scripts? I want to be able to see
> >a breakdo
: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
>Behalf Of Nancy L Backhaus
>Sent: Monday, November 22, 2004 12:59 PM
>To: [EMAIL PROTECTED]
>Subject: Select Statement Help for Volume Breakdown
>
>How do I combine these two scripts? I want to be able to see
>a breakdown
&g
How do I combine these two scripts? I want to be able to see a breakdown
by stg pools & breakdown of scratch/privates in the stgpools.
select status, count(*) from libvolumes where library_name = 'LTOLIB'
group by status
I have this..but, I really want to see the scratch/private breakdown?
s
t Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
select statement help
What is the select statement to tell what node is backing up certain
filespaces if the customer does not know the node name?
The filespace is:
/cagvsp1/entp/prod/
Thanks.
Jason
Propellervägen 6B
183 62 TÄBY
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51
"Cain, Jason (Corporate)" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
2004-10-07 16:32
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROT
What is the select statement to tell what node is backing up certain filespaces if the
customer does not know the node name?
The filespace is:
/cagvsp1/entp/prod/
Thanks.
Jason
Thanks for this. Interesting way of attacking it :)
Matt.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Johnson, Milton
Sent: Tuesday, August 31, 2004 10:19 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
You can create a script
-- ---
COPYPOOL >=50
TAPEPOOL >=50
H. Milton Johnson
Voice: (210) 677-6728
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Beha
EMAIL PROTECTED] Behalf Of
Prather, Wanda
Sent: Tuesday, August 31, 2004 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL
[mailto:[EMAIL PROTECTED] Behalf Of
Prather, Wanda
Sent: Tuesday, August 31, 2004 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Warren, Matthew (Retail)
Sent: Tuesday, August 31, 2004 10:51 AM
To: [EMAIL PROTECTED]
Subject: SQL Select statement help
Hallo ([I]T/AD)SM'ers
Can any wise and clever SQL types help with the following?;
I am trying to get TSM to show the number of tapes that went pending by
date.
I can get this;
ANS8000I Server command: 'select cast(pending_date as char(10)),count(*)
from volumes where status='PENDING' group by p
: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 */
/*
s "# of tapes" from volumes vo,
stgpools st where vo.DEVCLASS_NAME like 'LTO%' and
vo.STGPOOL_NAME=st.STGPOOL_NAME group by vo.STGPOOL_NAME
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ben
Bullock
Sent: Thursday, August 12, 2
Ok, this should be simple, but it's driving me nuts.
I have 2 simple select statements that I'm trying to combine
into 1 but it's not working.
Here are the 2 scripts and their output:
tsm: TSMSERV1A>select STGPOOL_NAME, MAXSCRATCH from stgpools where
DEVCLASS like
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
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.
Thanks
Justin Case
May 20, 2004 11:47 AM
To: [EMAIL PROTECTED]
Subject: Select Statement Help
q act search=0986 begintime=-1
How can I issue this query above using a select statement?
Thanks!
---
The information contained in this e-mail message, and any attachment
thereto,
q act search=0986 begintime=-1
How can I issue this query above using a select statement?
Thanks!
---
The information contained in this e-mail message, and any attachment thereto, is
confidential and may not be disclosed without our express permission. If
: 416-235-0265
Web: www.infinitynetwork.com
-Original Message-
From: Justin Bleistein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 12:44 PM
To: [EMAIL PROTECTED]
Subject: tsm select statement help
Does anyone have an sql syntax/statement example on how to join two sql
You're welcome!
-Original Message-
From: Justin Bleistein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 1:46 PM
To: [EMAIL PROTECTED]
Subject: Re: tsm select statement help
thanks you da man!.
--Justin Richard Bleistein
Unix/TSM Systems Administ
|
| To: [EMAIL PROTECTED]
|
| cc:
timestamp-backup_start)days as integer)>=60 -
order by stgpool_name, oc.node_name, oc.filespace_name
-Original Message-
From: Justin Bleistein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 12:44 PM
To: [EMAIL PROTECTED]
Subject: tsm select statement help
Does anyon
Does anyone have an sql syntax/statement example on how to join two sql
tables in adsm/tsm?
I have two tables in that adsm schema which both contain info that the
other doesn't respectively.
So I want to join them to get the desired results. I'm looking at Oracle
examples on the web none
really goo
51 matches
Mail list logo
