How to list a complete list of servers and directories backuped with TSM

Santiago videla
Santiago videla used Ask the Experts™
on
Hi everyone:
                         I need to create a report with the complete  list of servers and each of their respective directories protected by my TSM server. Is there any command to obtain this data?


Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,
you should use a couple of queries, 1 that gives you occupancy (this will read, among other useful info, only the volume on which directories reside) and one more that gives you what is defined into the client schedules (if you haven't used just "incremental" without specifying anything into the 'object' field; should you use incremental it will backup everything but excluded files)

1.
Select node_name, filespace_name,physical_mb, stgpool_name from occupancy order by physical_mb DESC

2.
select schedule_name, DOMAIN_NAME, OBJECTS, perunits, description, dayofweek, starttime from client_schedules order by starttime

hope it helps
max

Author

Commented:
Max! Thanks a lot! those commands give me exactly what i need! Thanks a lot, as usual!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial