Select distinct node_name,type,filespace_name,hl_name,ll_name from backups
where node_name='<desirednodename>' and type=DIR and
filespace_name='\\<nodename>\c$' and hl_name='\' order by node_name,
type,filespace_name,hl_name,ll_name

It will run a while though...

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lee, Gary
Sent: Thursday, November 07, 2013 8:15 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] sql query question

I want a list of all top level directories on a windows file system;
specifically, c:.

How can I get this from tsm?


The problem is I need to restore several directories, back to a machine with
a replaced hard disk.
However, I am totally blind, and unable to use the gui; so thought I would
create a macro to restore each top level directory, and then call it with a
schedule.

Thanks for any assistance.


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