1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Show size of Inactive Files

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

  1. redplumptomato

    redplumptomato New Member

    Aug 21, 2012
    Likes Received:
    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

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



Share This Page