Is the Q OCC command insufficient?

If not try this:

select node_name, stgpool_name from occupancy group by node_name,
stgpool_name

You can also add a where clause if you would like.

Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180