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