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 -----Original Message----- From: Joel Fuhrman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Re: SQL statement search www.adsm.org and will find hundreds of SQL examples. On Wed, 29 May 2002, Bernard Rosenbloom wrote: > 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 > [EMAIL PROTECTED] >
