ADSM-L

Re: SQL statement

2002-05-30 09:57:55
Subject: Re: SQL statement
From: Bernard Rosenbloom <brosenbl AT OPTONLINE DOT NET>
Date: Thu, 30 May 2002 09:53:18 -0400
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:joelf AT CAC.WASHINGTON DOT EDU]
> Sent: Wednesday, May 29, 2002 5:27 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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
> > brosenbl AT optonline DOT net
> >
<Prev in Thread] Current Thread [Next in Thread>