Re: Operational Hourly Monitors
If you go in and look at some of the queries already defined by Tivoli in the default hourly monitor it shows that the SQL WHERE clause compares the date/times "BETWEEN '%s" and '%s'" . I've used this syntax in my own queries and it works fine. I've never found any documentation on it, just a little reverse engineering. Since you can refresh the monitor on either the current time or the scheduled time, I'm going to assume the the %s's are calculated as NOW-1hour and NOW. Bill Boyer "Some days you're the bug, some days you're the windshield" - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Michael LaFrance Sent: Thursday, May 05, 2005 8:10 PM To: ADSM-L@VM.MARIST.EDU Subject: Operational Hourly Monitors I'm trying to set up an operational monitor that will alert our TSM operators that a tape is required from a "shelf" location. The shelf is where the archive tapes are stored and they are required from time to time for collocation. The hourly script will check the activity log for ANR8765I. My problem is setting the query to only search the last hour of the activity log. I can make it check the previous day but am stumped by this "past hour" report. Here is my TSQL script: select msgno, message from actlog where msgno=8765 and date(date_time)=current_date - 1 day I've tried to adjust this script to query just the last hour of the activity log but to no avail. Does anyone have any suggestions? Mike LaFrance Network Analyst Prospera Credit Union Tel 604-864-6638 Fax 604-850-3473 [EMAIL PROTECTED] This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you receive this email in error, please immediately notify the sender. Please note that this financial institution neither accepts nor discloses confidential member account information via email. This includes password related inquiries, financial transaction instructions and address changes.
Re: Operational Hourly Monitors
Michael - For techniques in handling relative time values in Selects, see: "Sample SQL Select Statements": http://www.ibm.com/support/entdocview.wss?uid=swg21049808 and http://people.bu.edu/rbs/ADSM.QuickFacts topic "Activity log, Select entries less than an hour old" Richard Sims On May 5, 2005, at 8:09 PM, Michael LaFrance wrote: I'm trying to set up an operational monitor that will alert our TSM operators that a tape is required from a "shelf" location. The shelf is where the archive tapes are stored and they are required from time to time for collocation. The hourly script will check the activity log for ANR8765I. My problem is setting the query to only search the last hour of the activity log. I can make it check the previous day but am stumped by this "past hour" report. Here is my TSQL script: select msgno, message from actlog where msgno=8765 and date(date_time)=current_date - 1 day I've tried to adjust this script to query just the last hour of the activity log but to no avail. Does anyone have any suggestions?
Operational Hourly Monitors
I'm trying to set up an operational monitor that will alert our TSM operators that a tape is required from a "shelf" location. The shelf is where the archive tapes are stored and they are required from time to time for collocation. The hourly script will check the activity log for ANR8765I. My problem is setting the query to only search the last hour of the activity log. I can make it check the previous day but am stumped by this "past hour" report. Here is my TSQL script: select msgno, message from actlog where msgno=8765 and date(date_time)=current_date - 1 day I've tried to adjust this script to query just the last hour of the activity log but to no avail. Does anyone have any suggestions? Mike LaFrance Network Analyst Prospera Credit Union Tel 604-864-6638 Fax 604-850-3473 [EMAIL PROTECTED] This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you receive this email in error, please immediately notify the sender. Please note that this financial institution neither accepts nor discloses confidential member account information via email. This includes password related inquiries, financial transaction instructions and address changes.