Try this:

SELECT NODES.NODE_NAME, MGMTCLASSES.CLASS_NAME
FROM MGMTCLASSES MGMTCLASSES, NODES NODES
WHERE NODES.DOMAIN_NAME = MGMTCLASSES.DOMAIN_NAME

John Stephens
Storage Solutions Specialists, Inc.
http://www.Storsol.com
Stephens AT Storsol DOT com
813-505-2526


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Tom Haddad
> Sent: Wednesday, March 31, 1999 1:05 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: ADSM v3.1 - SELECT
>
>
> Anyone know the SELECT command  needed
> to list each node name and what mgmtclass(s) its using.
>