1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

collect number of objects

Discussion in 'TSM Operation' started by TaSMania, Aug 31, 2017.

  1. TaSMania

    TaSMania ADSM.ORG Member

    Joined:
    Nov 17, 2015
    Messages:
    52
    Likes Received:
    1
    I'm asked to collect:
    Total number of objects and total amount of space occupied by the objects per TSM instance.

    Not sure where to begin. I'm looking through admin reference find: objects to see if any info would relates to this question but not sure. I'm guessing I have to Query for something. Query OCC * *?
     
  2.  
  3. RecoveryOne

    RecoveryOne ADSM.ORG Member

    Joined:
    Mar 15, 2017
    Messages:
    57
    Likes Received:
    6
    This may help:
    http://thobias.org/tsm/sql/#toc75
    That's for backup objects and size by filespace for a single node. There's other queries on Thobias for archive objects.
     
  4. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,608
    Likes Received:
    370
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    Check here: http://thobias.org/tsm/sql/ Under the "Occupancy" category, there's probably a query that does what you need or fairly close.
     
  5. TaSMania

    TaSMania ADSM.ORG Member

    Joined:
    Nov 17, 2015
    Messages:
    52
    Likes Received:
    1
    Thanks guys, just what I needed. Anyone else in TSM/ISP field that requires much sql knowledge as where I'm in?
     
  6. RecoveryOne

    RecoveryOne ADSM.ORG Member

    Joined:
    Mar 15, 2017
    Messages:
    57
    Likes Received:
    6
    Having some knowledge of SQL is handy. I'm by no means anything above a novice when it comes to it. Knowing a little bit of the syntax and what sort of tables are in TSM helps. Some things I still get stuck on which I will go ask our DBA's as to what I'm getting wrong. It's a learning opportunity!
     

Share This Page