Gary,

I think this will give you want you want.  Change the node_name  for your 
environment:

select filespace_name,hl_name,ll_name from backups where node_name='DEEHRE01' 
and state='ACTIVE_VERSION' and type='DIR' and hl_name='\'

David



-----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 9: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