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:[email protected]] On Behalf Of Lee, Gary Sent: Thursday, November 07, 2013 9:15 AM To: [email protected] 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
