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: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."
Christo Heuër <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 12/19/2000 02:31:40
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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: [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]
> >