Hi Andy, David,
This info is kept in the summary table on Tsm3.7 servers. Here is an example
of of a select * from summary query: (Note the address field).
START_TIME: 2000-11-20 19:05:55.000000
END_TIME: 2000-11-20 19:35:38.000000
ACTIVITY: BACKUP
NUMBER: 274
ENTITY: LEGALJHB
COMMMETH: Tcp/Ip
ADDRESS: 10.0.8.34:2177
SCHEDULE_NAME:
EXAMINED: 2977
AFFECTED: 2977
FAILED: 0
BYTES: 638352864
IDLE: 99
MEDIAW: 0
PROCESSES: 1
SUCCESSFUL: YES
Cheers
Christo
> Actually this info isn't in the NODES table, either. The TSM server stores
> the IP addresses for nodes using the PROMPTED scheduling mode only, so the
> server knows which address to prompt when it is time to run scheduled
> events. However, the table in which this data resides has not been
> externalized, so it can not be accessed by any QUERY or SELECT statement.
>
> Regards,
>
> Andy
>
> Andy Raibeck
> IBM/Tivoli
> Tivoli Storage Manager Client Development
> e-mail: [EMAIL PROTECTED]
> "The only dumb question is the one that goes unasked."
>
>
>
> I am sory to correct you, but there is a field in the nodes table that
> stores the hex IP address of the client.
>
> Keith Davey
>
>
> On Mon, 18 Dec 2000, Williams, Tim wrote:
>
> > I don't think that it really 'stores' that information, per se.
> > IT, is however logged in the activity log....
> > q actlog.....search=....etc.... (help q actlog)
> > hope this helps...
> >
> >
> >
> >
> > David Longo <[EMAIL PROTECTED]>
> > 12/18/2000 02:24 PM
> > Please respond to "ADSM: Dist Stor Manager"
> > <[EMAIL PROTECTED]>@SMTP@Exchange
> > To: [EMAIL PROTECTED]@SMTP@Exchange
> > cc:
> >
> > Subject: General *SM database/ IP address question
> >
> > When you register a node name and the node first contacts the
*SM
> > Server, the server stores the IP address of the client. Where is this
IP
> > address stored on the server?
> >
> >
> > David B. Longo
> > Systems Administrator
> > Health First, Inc. I/T
> > 3300 Fiske Blvd.
> > Rockledge, FL 32955-4305
> > PH 321.434.5536
> > Pager 321.634.8230
> > Fax: 321.434.5525
> > [EMAIL PROTECTED]
> >
