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