I hope this is what you are looking for.
select node_name,stgpool_name from occupancy

similar to
q occup


Sung Y. Lee
512-823-1012



                      Bernard
                      Rosenbloom               To:       ADSM-L AT VM.MARIST 
DOT EDU
                      <brosenbl@OPTONLI        cc:
                      NE.NET>                  Subject:  SQL statement
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      05/29/2002 10:04
                      AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"





I have an immediate need to create a list of all my registered nodes and
the storage pool(s) each node backs up to. I know almost nothing about
creating an SQL statement so if anyone can assist, I would appreciate it
very much.



Thank You
Bernard Rosenbloom
brosenbl AT optonline DOT net