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:
NOT LIKE '%$%' GROUP
BY NODE_NAME
Bruce Kamp
TSM Administrator
(817) 568-7331
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Hanover, Cameron
Sent: Tuesday, March 10, 2015 11:05 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
: 03/09/15 12:46
Subject:[ADSM-L] Select Statement Help
Sent by:ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
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
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
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
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
] 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 verify the output, only
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
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
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
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?
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
by stg pools breakdown of scratch
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
by stg pools breakdown of scratch/privates in the stgpools.
select status, count(*) from libvolumes where library_name = 'LTOLIB'
group
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
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 PROTECTED]
To
[EMAIL PROTECTED]
cc
Subject
select statement help
What
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
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
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
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
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 PROTECTED] On Behalf
] 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 PROTECTED] On Behalf Of
Warren
Johnson
Voice: (210) 677-6728
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On 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
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
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: TSMSERV1Aselect STGPOOL_NAME, MAXSCRATCH from stgpools where
DEVCLASS like
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, 2004 11:46 AM
To: [EMAIL PROTECTED]
Subject: 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.
Thanks
Justin Case
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
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
, 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
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
-
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 anyone have an sql syntax/statement example on how
]
|
| cc:
|
| Subject: Re: tsm select statement help
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 Administrator
: 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
51 matches
Mail list logo