I don't think that Tivoli digs any deeper than the base level.
there are windows scripts that will return that info. You
could either manually run one on each client, or set it to run as part
of a pre or post schedule command.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Avy Wong
Sent: Friday, October 03, 2008 12:20 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: window OS, SP version and TSM client version


Thanks Doug. Is there a way to also capture the Window Service pack version
into the select statement?

Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976




             "Thorneycroft,
             Doug"
             <dthorneycroft@LA                                          To
             CSD.ORG>                  ADSM-L AT VM.MARIST DOT EDU
             Sent by: "ADSM:                                            cc
             Dist Stor
             Manager"                                              Subject
             <[email protected]         Re: [ADSM-L] window OS, SP version
             .EDU>                     and TSM client version


             10/03/2008 03:11
             PM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






select node_name as node, CLIENT_OS_LEVEL as OSVer, client_version as v,
client_release as r, client_level as l, client_sublevel as sl from nodes
order by v,r,l,sl >c:\Outputfilename.txt

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Avy Wong
Sent: Friday, October 03, 2008 12:08 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: window OS, SP version and TSM client version


Hello,
      Is there anyway  I can run a select statement to capture the node
names, TSM client version, Window OS and SP version?
I see vss error popping out more than usual, and I want to determine the SP
version on the Window boxes without logging into each box to find out.
Thank you for y our help.

Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976