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.

Querry help

Discussion in 'Command Line Administrator Client' started by cwilloug, Dec 14, 2012.

  1. cwilloug

    cwilloug ADSM.ORG Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    390
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    I thought I had a querry once upon a time, I'm looking for querry, if possible, on how many tapes a specific node is using? Does anyone have any idea? Is this possible?

    Thanks

    Have a good weekend!!
     
  2.  
  3. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,535
    Likes Received:
    299
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    select volumes from volumeusage where node_name='node_name' and stgpool_name='stgpool_name'
     
  4. LED888

    LED888 ADSM.ORG Moderator

    Joined:
    Oct 15, 2002
    Messages:
    780
    Likes Received:
    56
    Something like - query nodedata

    Good Luck,
    Sias
     
  5. ChrisRees

    ChrisRees ADSM.ORG Senior Member

    Joined:
    Jul 24, 2008
    Messages:
    539
    Likes Received:
    13
    Occupation:
    Storage Management Person
    Location:
    Birmingham, UK
    A slightly different take on moon-buddy' select statement

    select stgpool_name, count(*) from volumeusage where node_name='node_name' group by stgpool_name
     
    admin likes this.

Share This Page