Re: restore volumes list. It's possible??
Hello, I'm looking for a query or sql script that allow me to see what volumes I'll need for a restore process. I want to see the volumes before the starting of the process. If your question is concerning nodes you can try to implement the following actions. We perform this by program in a product (SOS-Log that we sell only in France, sorry) so you'll have to adapt it in SQL (if possible or by script). Start with : select DISTINCT VOLUME_NAME NODE_NAME COPY_TYPE STGPOOL_NAME from VOLUMEUSAGE crossing it with POOL_TYPE from STGPOOLS on STGPOOL_NAME sort by COPY_TYPE of VOLUMUSAGE (BACKUP, ARCHIVE) then sort the result by NODE_NAME Be careful, select on volumeusage is sometime very slow Likewise I need a query or script that allow me to see what volumes I'll need for a backup stgpool process. When I use preview=volumesonly or yes I realize not always ask me the volumes that are in the list this command has generated. Is there another way to do this? Maybe something like (again you'll have to adpat in good SQL syntax) : select volume_name from volumes where last_write_date your date time and stgpool_name = your stgpool your date time is the TSM date time of the last copy Hope this helps If you read french, you can have a look at an example (somehow old) : http://www.sos-restore.com/demolog/log.htm Best regards Christian Bagard Tél :(33) 442 930 813 email : [EMAIL PROTECTED] SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France www.sos-restore.com (only french sorry)
Re: restore volumes list. It's possible??
Here is what you will need select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='x'
Re: restore volumes list. It's possible??
I'm looking for a query or sql script that allow me to see what volumes I'll need for a restore process. ... This is a frequently asked question. The short answer is that there is no way for you to obtain such a list. See topic Restoral preview in http://people.bu.edu/rbs/ADSM.QuickFacts for elaboration. Richard Sims
Re: RESTORE VOLUMES: other suggestions: a real answer to your que stion
Gary, We are also a Veritas NetBackup user. Thank God TSM has a facility like the SQL query to search their databases and generate whatever I want already built in. I admit I had to learn SQL a few years ago to write a mainframe application (RMDS extensions) that did some really complex SQL queries. So, I was quick to jump on the SQL features of TSM. It took me about a week to become a very proficient SQL coder and about another to learn what a stupid SQL query with inner and outer joins could do to a system if not coded correctly. There are several inevitabilities in our industry. One, flat files are a thing of the past. Second, every database application being built today is relational that can do anything. TSM is a database application unlike any other storage management product. As a result you can do things with it that are not possible with competitive offerings. So, the third inevitability has arisen. Systems people that do not retire soon will be lost without basic SQL knowledge. You being a MCSE are keenly aware of this. Now, I would like to reemphasize what others have said about ODBC since you are a Microsoft knowledgeable person. If you install the ODBC driver (anywhere) you can use ACCESS to link to the TSM tables (do not recommend import). If you have any ACCESS background, you know that its filter information does basicall a select. You can see those in the log. The ODBC driver takes all of 5 minutes to install and setup. Sorry the current QUERY CONTENT command does not support splat for volume. The QUERY OCC command would help you significantly in your quest if it supported '*' as valid option for the volume. However this is what the SQL would look like: SELECT volume_name, node_name, filespace_name from contents where node_name='your node' group by volume_name, node_name, filespace_name order by volume_name However, this query takes for ever to run. So, it is kind of useless. -Original Message- From: Alex Paschal [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:26 PM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES Gary, Not SQL, just SQL Queries. It's a much smaller knowledge set. Also, I agree with the recommendation for learning some kind of scripting language. Perl, shell script, C. Or shudder VB or Windows Scripting Host. Anything you can use to automate your job creates time for personal growth, keeping up on the industry, or, my favorite, golf. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Gary Swanton [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:43 AM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES Hi Michel, Thanx for your assistance. It continually frustrates me that here is a product that out of the box requires the user (read admin) to have another skill set ie SQL just so he can do reasonable job. An admin without the skill set to create SQL queries and alike (like me) will find that TSM out of the box is about as efficient as an ashtray on a motorbike. Guess I better get myself on a course to learn SQL... Thanx again.. Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Friday, 15 February 2002 4:13 AM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES Hi Garry CStringArray is a class in MFC (You shlould use ODBC to connect TSM tables and a Programming language) If you DO not use C++ or something like it. You have to use some script editor (PERL...) I use Norton Dos. Little example of script. SETLOCAL PUSHD C:\Program Files\Tivoli\TSM EchoC:\Command.txt select file_name from contents where volume_name='vol1' DSMADMC -id=admin -password=admin -noconfirm c:\Command.txt C:\Results.TXT POPD ENDLOCAL This will just generate a file with the file_name contents of the tape 'vol1' This is a basis. I hope you can continue. Good luck Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi Michel, Thank you for your quick response. Not too sure what you mean at step 2 - CStringArray - Could you please decode that bit for me Regards Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Wednesday, 13 February 2002 8:21 PM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES It's possible Take a look at the ARCHIVES and essentially CONTENTS table 1) select * from contents where volume_name='vol1' You will get everything in the volume vol1. 2) Save the info (file_name) in some CStringArray 3) Sort your info to restore according to the volumes Good luck. Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform
Re: RESTORE VOLUMES
Hi Michel, Thanx for your assistance. It continually frustrates me that here is a product that out of the box requires the user (read admin) to have another skill set ie SQL just so he can do reasonable job. An admin without the skill set to create SQL queries and alike (like me) will find that TSM out of the box is about as efficient as an ashtray on a motorbike. Guess I better get myself on a course to learn SQL... Thanx again.. Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Friday, 15 February 2002 4:13 AM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES Hi Garry CStringArray is a class in MFC (You shlould use ODBC to connect TSM tables and a Programming language) If you DO not use C++ or something like it. You have to use some script editor (PERL...) I use Norton Dos. Little example of script. SETLOCAL PUSHD C:\Program Files\Tivoli\TSM EchoC:\Command.txt select file_name from contents where volume_name='vol1' DSMADMC -id=admin -password=admin -noconfirm c:\Command.txt C:\Results.TXT POPD ENDLOCAL This will just generate a file with the file_name contents of the tape 'vol1' This is a basis. I hope you can continue. Good luck Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi Michel, Thank you for your quick response. Not too sure what you mean at step 2 - CStringArray - Could you please decode that bit for me Regards Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Wednesday, 13 February 2002 8:21 PM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES It's possible Take a look at the ARCHIVES and essentially CONTENTS table 1) select * from contents where volume_name='vol1' You will get everything in the volume vol1. 2) Save the info (file_name) in some CStringArray 3) Sort your info to restore according to the volumes Good luck. Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com
Re: RESTORE VOLUMES
Gary, Not SQL, just SQL Queries. It's a much smaller knowledge set. Also, I agree with the recommendation for learning some kind of scripting language. Perl, shell script, C. Or shudder VB or Windows Scripting Host. Anything you can use to automate your job creates time for personal growth, keeping up on the industry, or, my favorite, golf. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Gary Swanton [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 12:43 AM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES Hi Michel, Thanx for your assistance. It continually frustrates me that here is a product that out of the box requires the user (read admin) to have another skill set ie SQL just so he can do reasonable job. An admin without the skill set to create SQL queries and alike (like me) will find that TSM out of the box is about as efficient as an ashtray on a motorbike. Guess I better get myself on a course to learn SQL... Thanx again.. Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Friday, 15 February 2002 4:13 AM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES Hi Garry CStringArray is a class in MFC (You shlould use ODBC to connect TSM tables and a Programming language) If you DO not use C++ or something like it. You have to use some script editor (PERL...) I use Norton Dos. Little example of script. SETLOCAL PUSHD C:\Program Files\Tivoli\TSM EchoC:\Command.txt select file_name from contents where volume_name='vol1' DSMADMC -id=admin -password=admin -noconfirm c:\Command.txt C:\Results.TXT POPD ENDLOCAL This will just generate a file with the file_name contents of the tape 'vol1' This is a basis. I hope you can continue. Good luck Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi Michel, Thank you for your quick response. Not too sure what you mean at step 2 - CStringArray - Could you please decode that bit for me Regards Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Wednesday, 13 February 2002 8:21 PM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES It's possible Take a look at the ARCHIVES and essentially CONTENTS table 1) select * from contents where volume_name='vol1' You will get everything in the volume vol1. 2) Save the info (file_name) in some CStringArray 3) Sort your info to restore according to the volumes Good luck. Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com
Re: RESTORE VOLUMES
Hi Garry CStringArray is a class in MFC (You shlould use ODBC to connect TSM tables and a Programming language) If you DO not use C++ or something like it. You have to use some script editor (PERL...) I use Norton Dos. Little example of script. SETLOCAL PUSHD C:\Program Files\Tivoli\TSM EchoC:\Command.txt select file_name from contents where volume_name='vol1' DSMADMC -id=admin -password=admin -noconfirm c:\Command.txt C:\Results.TXT POPD ENDLOCAL This will just generate a file with the file_name contents of the tape 'vol1' This is a basis. I hope you can continue. Good luck Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi Michel, Thank you for your quick response. Not too sure what you mean at step 2 - CStringArray - Could you please decode that bit for me Regards Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Wednesday, 13 February 2002 8:21 PM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES It's possible Take a look at the ARCHIVES and essentially CONTENTS table 1) select * from contents where volume_name='vol1' You will get everything in the volume vol1. 2) Save the info (file_name) in some CStringArray 3) Sort your info to restore according to the volumes Good luck. Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com
Re: RESTORE VOLUMES
It's possible Take a look at the ARCHIVES and essentially CONTENTS table 1) select * from contents where volume_name='vol1' You will get everything in the volume vol1. 2) Save the info (file_name) in some CStringArray 3) Sort your info to restore according to the volumes Good luck. Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com
Re: RESTORE VOLUMES
Hi Michel, Thank you for your quick response. Not too sure what you mean at step 2 - CStringArray - Could you please decode that bit for me Regards Gary -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Michel David Sent: Wednesday, 13 February 2002 8:21 PM To: [EMAIL PROTECTED] Subject: Re: RESTORE VOLUMES It's possible Take a look at the ARCHIVES and essentially CONTENTS table 1) select * from contents where volume_name='vol1' You will get everything in the volume vol1. 2) Save the info (file_name) in some CStringArray 3) Sort your info to restore according to the volumes Good luck. Michel --- Gary Swanton [EMAIL PROTECTED] wrote: Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com
Re: RESTORE VOLUMES
Gary, I understand your frustration at starting out, but the SQL command for this request is not difficult and has been answered on this list a number of times. It is difficult to pull that information out with all the activity and matches that you get, however, so feel free to ask such questions here. One format of the command you need is: select volume_name, stgpool_name, filespace_name from volumeusage where node_name='NODENAME' where NODENAME is the name of the node in question in all caps. That will show you which primary and copy pool tapes you need for the restore. To just see the tapes for a specific storage pool for you case, add a selection of the storage pool name: select volume_name, stgpool_name, filespace_name from volumeusage where node_name='NODENAME' where stgpool_name='TAPEPOOL' where TAPEPOOL is the name of your primary tape pool. As you already know, this is not necessary if you have enough robot slots to hold all your primary tapepool tapes. Proper sizing of a TSM environment before purchase is quite important. Bill Smoldt STORServer -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Gary Swanton Sent: Wednesday, February 13, 2002 2:02 AM To: [EMAIL PROTECTED] Subject: RESTORE VOLUMES Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED]
Re: RESTORE VOLUMES
you could try show voluse where is the nodename of the client you want to restore. this would however, tell you every tape that this client has data on. Which would be more then what you are looking for and it sounds like you are not using co-location so your list would be quite large. Gary Swanton [EMAIL PROTECTED]@VM.MARIST.EDU on 02/13/2002 04:01:39 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: RESTORE VOLUMES use Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED]
Re: RESTORE VOLUMES
Gary - you can get the volume names for the volumeusage table. Here is a macro to do the select; cut and paste the macro to a file, then in dsmadmc enter macro file_name 'NODE_NAME' = 'filespace_name'. The output will be in the file c:\tsmvolumes.txt. Hope this helps. /* */ /* macro file to select the volumes that a node */ /* is stored on.*/ /* */ set sqldatetimeformat i set sqldisplaymode w set sqlmathmode r commit select distinct copy_type, left(node_name,16), left(volume_name,16), - left(stgpool_name,16) - from adsm.volumeusage - where node_name = %1 - and copy_type in ('BACKUP', 'ARCHIVE') - and filespace_name %2 %3 - c:\tsmvolumes.txt At 08:01 PM 2/13/2002 +1100, you wrote: Hi All, I am quite new to all things TSM and I have a question to what I believe is an unrealistic situation. Presently if, during my role as the TSM administrator I am asked to perform a data restore, I have no idea of what volumes will be required for the data. I have a 30 slot library at my disposal, which I appreciate is quite small, however, if after I kick off a restore I should have some indication as to what volumes are required thereby allowing me to check the volumes into the library before the restore job commences. A recent example: I had to restore 80MB worth of data and it took over 3.5 hours and over 18 tape changes. The present situation is that after I start a restore I have to be glued to the console and wait for tape requests to appear in the activity log or via a pop-up. My research has shown that other people have been asking the same thing as far back as 1998 but no-one appears to have provided a solution. Tivoli have told me that it is possible with some pretty complex SQL statements. Great now I have to learn SQL queries as well. Does anybody have any ideas on this matter? It's not that hard surely..Oh yeah I'm running TSM Server 4.2.10 on a W2K platform with current clients running 4.2.1. Gary Swanton Microsoft Certified Systems Engineer [EMAIL PROTECTED] -- Bill Colwell C. S. Draper Lab Cambridge Ma.