Hi Pavel, The following SQL command provides an output similar to "q ev * * f=d" and output it to a file; you can incorporate it into a script if needed. I ran the query against the "EVENTS" table.
select distinct events.node_name as "Node", events.domain_name as "Domain Name", events.scheduled_start "Scheduled Start", events.actual_start as "Actual Start", events.completed as "Completed", events.status as "Backup Status", events.result as "Results", events.reason as "Reason" from events ORDER BY events.node_name >> c:\queryevent.txt I hope it helps. BERTAUT TCHUISE Storage Support Administrator Legg Mason Technology Services *410-580-7032 [email protected] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Pavel Sitnikov Sent: Thursday, June 25, 2009 6:10 AM To: [email protected] Subject: [ADSM-L] How can I insert "Completed" column in report? Hi, sql queries guru need some script for my custom OR rep with output like TSM command "q ev * * f=d" I know about standart "Client Schedules Status" report and use it. But it have only one option setting in OR - Node Filter. And report output doesn't have "Completed" column, only "Schedule Start" and "Actual Start". Command output "q ev * * f=d" include this column. How can I insert "Completed" column in report? Thx in advance! IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
