Where do you get the syntax information for the select statement? i.e. substr , etc. Thank you.
To ADSM-L@VM.MARIST.EDU cc From Sent by Leigh Reed <[EMAIL PROTECTED]> on 05/25/2006 05:04 AM "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> Subject Re: [ADSM-L] Select Statements Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> Roger I recently had to query the summary table for info regarding the database backups. My requirement was to report how long the database backups were taking. I found that the following select query sufficed. select substr(char(end_time-start_time),3,8) as backup_duration from summary where activity='FULL_DBBACKUP' I know this is not exactly what you are asking, but from the construct, you should be able alter it to do exactly the things you require. Also, the following query will return all the fields that are available for database backups in the summary table select * from summary where activity='FULL_DBBACKUP' HTH Leigh -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 24 May 2006 21:24 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger DISCLAIMER: This communication, along with any documents, files or attachments, is intended only for the use of the addressee and may contain legally privileged and confidential information. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of any information contained in or attached to this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately and destroy the original communication and its attachments without reading, printing or saving in any manner. This communication does not form any contractual obligation on behalf of the sender or, the sender's employer, or the employer's parent company, affiliates or subsidiaries.