Results 1 to 4 of 4

Thread: Querry help

  1. #1
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Talking Querry help

    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. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,858
    Thanks
    4
    Thanked 228 Times in 223 Posts

    Default

    select volumes from volumeusage where node_name='node_name' and stgpool_name='stgpool_name'
    Ed

  3. #3

    Default

    Something like - query nodedata

    Good Luck,
    Sias

  4. #4
    Senior Member
    Join Date
    Jul 2008
    Location
    Birmingham, UK
    Posts
    537
    Thanks
    0
    Thanked 5 Times in 4 Posts

    Default

    A slightly different take on moon-buddy' select statement

    select stgpool_name, count(*) from volumeusage where node_name='node_name' group by stgpool_name

Similar Threads

  1. SQL querry Data backedup each year/month
    By tsmdumber in forum Scripting
    Replies: 5
    Last Post: 02-24-2011, 08:12 AM
  2. dsmc querry access failed with error message ans1302
    By nickalai17 in forum Administrative Client
    Replies: 0
    Last Post: 04-12-2008, 03:42 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •