Q OCC gives me for info then I need but your SQL statement is exactly what I was looking for...thanks
"Seay, Paul" wrote: > 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] > >
