ADSM-L

sql select to count volumes per stgpool by node

2003-05-01 20:50:23
Subject: sql select to count volumes per stgpool by node
From: Joel Fuhrman <joelf AT CAC.WASHINGTON DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 1 May 2003 17:49:39 -0700
What is the syntax of the select statement to show the number of distinct
volumes used by each stgpool for each node.  The desired output would be
something like:

Node_Name   StgPool_Name  Count
---------   ------------  ------
yakima      backupcopy         5
yakima      backuptape         3
yakima      arccopy            7
yakima      arctape            6
olympia     backupcopy        23
olympia     backuptape        15
...

<Prev in Thread] Current Thread [Next in Thread>