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.

Querry help

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

  1. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    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 Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,228
    Likes Received:
    279
    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 Moderator

    Joined:
    Oct 15, 2002
    Messages:
    725
    Likes Received:
    50
    Something like - query nodedata

    Good Luck,
    Sias
     
  5. ChrisRees

    ChrisRees Senior Member

    Joined:
    Jul 24, 2008
    Messages:
    537
    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