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.

Show size of Inactive Files

Discussion in 'Scripting' started by redplumptomato, Sep 14, 2012.

  1. redplumptomato

    redplumptomato ADSM.ORG Member

    Joined:
    Aug 21, 2012
    Messages:
    69
    Likes Received:
    0
    Hi there,

    I'm new to this board. I hope I'm posting in the right place.

    I wrote a simple script which shows you the total # of inactive files for a node.

    >select count(*) as Total from backups where node_name='$1'
    and state='INACTIVE_VERSION'

    very simple..

    But, what I'd like to do, is have another column which shows total size.. Is there a way to do this?

    I also found this script online, which shows you a complete list..

    > Select filespace_name as Filespace, hl_name as Directory,
    ll_name as Filename, state as State from backups where
    node_name='$1'

    It would be great to also have a column for size.. Any ideas?

    Thanks..

    RPT
     
  2.  

Share This Page