: 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%
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
-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
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
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
..@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
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
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
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.
>
&
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
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
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
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
>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
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
15 matches
Mail list logo