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
BTchuise AT leggmason DOT com


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Pavel Sitnikov
Sent: Thursday, June 25, 2009 6:10 AM
To: ADSM-L AT VM.MARIST DOT EDU
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.