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" <[EMAIL PROTECTED] To CSD.ORG> ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] Behalf Of Avy Wong Sent: Friday, October 03, 2008 12:08 PM To: ADSM-L@VM.MARIST.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