ADSM-L

Re: SQL command

2002-03-06 16:59:52
Subject: Re: SQL command
From: "Williams, Tim P {PBSG}" <Tim.Williams AT PBSG DOT COM>
Date: Wed, 6 Mar 2002 15:56:52 -0600
whoops I didn't read the whole request.
Mind you, this select command is going to give you what mgmtclases are
available to each of the nodes...

so:
tsm: ADSM>select nodes.node_name, mgmtclasses.class_name from nodes,
mgmtclasses where nodes.do          main_name=mgmtclasses.domain_name

NODE_NAME              CLASS_NAME
------------------     ------------------
BFLOYD                 10_DAY_RETENTION
BFLOYD                 10_DAY_RETENTION
BFLOYD                 30_DAY_RETENTION
BFLOYD                 5_DAY_RETENTION
BFLOYD                 60_DAY_RETENTION
BFLOYD                 90_DAY_RETENTION

<Prev in Thread] Current Thread [Next in Thread>