Hi, If you install the TSM ODBC Driver and point it at your TSM Server's IP Address and Port 1500, you can do this query in Excel or MS Access. In MS Excel click on Data, Get external data, new database query, Click on the Data Source name that is your ODBC connection Name, and log in to your TSM Server. This will give you a list of tables in your TSM Database.
Tom Ammann Server Specialist Purdue Pharma LP (203) 588-8117 -----Original Message----- From: Bernard Rosenbloom [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: SQL statement I have an immediate need to create a list of all my registered nodes and the storage pool(s) each node backs up to. I know almost nothing about creating an SQL statement so if anyone can assist, I would appreciate it very much. Thank You Bernard Rosenbloom [EMAIL PROTECTED]