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: andrew.raibeck AT tivoli DOT com
> "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 <David.Longo AT HEALTH-FIRST DOT ORG>
> >         12/18/2000 02:24 PM
> >         Please respond to "ADSM: Dist Stor Manager"
> > <ADSM-L AT VM.MARIST DOT EDU>@SMTP@Exchange
> >         To:     ADSM-L AT VM.MARIST DOT EDU@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
> >         david.longo AT health-first DOT org
> >