Hi James, There is probably an example like you are looking for here: http://thobias.org/tsm/sql/
- Thanks, Marc... ________________________________________________________ Marc Lanteigne Accelerated Value Specialist for Spectrum Protect 416.478.0233 | marclantei...@ca.ibm.com Office Hours: Monday to Friday, 7:00 to 16:00 Eastern Follow me on: Twitter, developerWorks, LinkedIn -----Original Message----- From: Lepre, James [mailto:james.le...@solixinc.com] Sent: Monday, January 22, 2018 10:45 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL STATEMENT Hey Everyone - I am looking for a sql select statement that show completions, missed, and failures of daily schedules. This output should be similar to the q event command Thank you in advance for the assistance James Lepre --------------------------------------------------------------- Confidentiality Notice: The information in this e-mail and any attachments thereto is intended for the named recipient(s) only . This e-mail, including any attachments, may contain information that is privileged and confidential and subject to legal restrictions and penalties regarding its unauthorized disclosure or other use. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action or inaction in reliance on the contents of this e-mail and any of its attachments is STRICTLY PROHIBITED. If you have received this e-mail in error, please immediately notify the sender via return e-mail; delete this e-mail and all attachments from your e-mail system and your computer system and network; and destroy any paper copies you may have in your possession. Thank you for your cooperation.
