Hi Christo,

Thank you for pointing this out. I stand corrected.   :-)

Please note, though, that the information is not kept permanently, and will
expire after the number of days specified by the Activity Summary Retention
Period (via SET SUMMARYRETENTION). So it may not be complete.

Best 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."


Christo Heuër <christoh AT ABSA.CO DOT ZA>@VM.MARIST.EDU> on 12/19/2000 02:31:40

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: General *SM database/ IP address question



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
> >