1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

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:
    47
    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:
    35
    Likes Received:
    4
    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,533
    Likes Received:
    354
    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:
    47
    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:
    35
    Likes Received:
    4
    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