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

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.
Santiago videlaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

max_the_kingCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Santiago videlaAuthor Commented:
Max! Thanks a lot! those commands give me exactly what i need! Thanks a lot, as usual!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
TSM Tivoli Storage Manager

From novice to tech pro — start learning today.