Wanda, that did it.  My life just got easier.

Thanks.
 


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Prather, Wanda
Sent: Thursday, March 11, 2010 1:32 PM
To: ADSM-L AT VM.MARIST DOT 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%'



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Thomas Denier
Sent: Wednesday, March 10, 2010 10:47 AM
To: ADSM-L AT VM.MARIST DOT 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 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 can help with this query, I'd appreciate it.

Other respondants have covered the matter of finding the last
backup date for existing system file backups. You can find
find Windows client nodes with no 'SYSTEM OBJECT' or 'SYSTEM
STATE' backups as follows:

select node_name from nodes where platform_name='WinNT' and
node_name not in (select node_name from filespaces where
filespace_name in ('SYSTEM OBJECT', 'SYSTEM STATE'))

We are starting to see small numbers of Windows 2008 client
systems. These use a new naming convention for filespaces
containing system file backups, such as:

WIN2008SRV\SystemState\NULL\System State\SystemState

for a test system named win2008srv.