Re: Filespace query

2010-03-11 Thread Lee, Gary D.
: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Filespace query It's not just Win2008, the new naming convention for SystemState started at the 5.5 client, so you'll see it for Win2K3 as well. I think this will get it.. select ... where upper(filespace_name) like '%SYSTEMSTATE%&#x

Re: Filespace query

2010-03-11 Thread Prather, Wanda
Manager [mailto:ads...@vm.marist.edu] On Behalf Of Thomas Denier Sent: Wednesday, March 10, 2010 10:47 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Filespace query -Gary Lee wrote: - >Tsm server 5.5.4, clients range from 5.0 through 6.3. > >Trying to construct a query to show me all

Re: Filespace query

2010-03-10 Thread Thomas Denier
-Gary Lee wrote: - >Tsm server 5.5.4, clients range from 5.0 through 6.3. > >Trying to construct a query to show me all windows nodes, whether >they have a filespace systemobject or systemstate, and when it was >last backed up. >Q filespace > >Comes close, and maybe I'll just need to rattl

Re: Filespace query

2010-03-10 Thread Richard Sims
SELECT Left(CHAR(BACKUP_END),19) as "LAST COMPLETE BACKUP", Char(NODE_NAME,10) as "NODE NAME", - Left(FILESPACE_NAME,25) as "FILESPACE NAME ", FILESPACE_TYPE as "FILE SYSTEM TYPE" - From FILESPACES Where BACKUP_END is not null - and FILESPACE_NAME in ('SYSTEM OBJECT', 'SYS

Re: Filespace query

2010-03-10 Thread Fred Johanson
Of Grigori Solonovitch Sent: Wednesday, March 10, 2010 8:14 AM To: ADSM-L@vm.marist.edu Subject: Re: [ADSM-L] Filespace query Try script or query from script: define script A2_Last_Client_Backups description="List of last file space backups for nodes" update script A2_Last_Client

Re: Filespace query

2010-03-10 Thread Grigori Solonovitch
..@vm.marist.edu] On Behalf Of Lee, Gary D. Sent: Wednesday, March 10, 2010 5:02 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Filespace query Tsm server 5.5.4, clients range from 5.0 through 6.3. Trying to construct a query to show me all windows nodes, whether they have a filespace systemobje

Filespace query

2010-03-10 Thread Lee, Gary D.
Tsm server 5.5.4, clients range from 5.0 through 6.3. Trying to construct a query to show me all windows nodes, whether they have a filespace systemobject or systemstate, and when it was last backed up. Q filespace Comes close, and maybe I'll just need to rattle that data around. If anyone ca

Re: Filespace query

2005-01-24 Thread Jones, Eric J
Thanks for the help. Worked great and I have exactly what I want. Thanks again, Eric -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Andrew Raibeck Sent: Monday, January 24, 2005 2:14 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Filespace query Whoops

Re: Filespace query

2005-01-24 Thread Andrew Raibeck
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of > Andrew Raibeck > Sent: Monday, January 24, 2005 1:14 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: Filespace query > > > Try tacking on the NAMETYPE=UNICODE option on the QUERY FILESPACE > command. > &

Re: Filespace query

2005-01-24 Thread Todd Lundstedt
Shouldn't you be using the "query occupancy" command? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Eric J Sent: Monday, January 24, 2005 12:54 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Filespace query Thanks. I ca

Re: Filespace query

2005-01-24 Thread Jones, Eric J
ry 24, 2005 1:14 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Filespace query Try tacking on the NAMETYPE=UNICODE option on the QUERY FILESPACE command. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROT

Re: Filespace query

2005-01-24 Thread Andrew Raibeck
Try tacking on the NAMETYPE=UNICODE option on the QUERY FILESPACE command. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one

Filespace query

2005-01-24 Thread Jones, Eric J
Good Afternoon. Is there an easy way to see how much space the SYSTEM OBJECT is taking up on a particular client? I can see what the "total space" that the client uses but I'd like to find out the individual filespaces(total). I tried to do aquery filespace owgwttsm "SYSTEM OBJECT" f=dand

Re: filespace query

2000-08-11 Thread Richard Sims
>I would like to know how you can find out how much data(MB) was backup, and at >what rate(KB/S) for filespace(s) that belong to a backup node. Not so easy...which makes for an opportunity for those 3rd party software developers. The information is in the database, though getting it is tediou

filespace query

2000-08-10 Thread Raymond Chao
To: [EMAIL PROTECTED] cc: I am writing a script for a client whcih basically shows backup details of filespaces backup for their node. I would like to know how you can find out how much data(MB) was backup, and at what rate(KB/S) for filespace(s) that belong to a backup node. I have looke