[ADSM-L] Sql assistance in tsm 6.2.2
2011-09-22 15:35:21
Trying to convert the following script from tsm 5.5.4 to 6.2.2.
Want to check exipiration performance and then bakcup performance (another
script).
Script follows:
select activity, cast ((end_time) as date) as "Date", -
(examined/cast ((end_time-start_time) seconds as decimal (18,13)) *3600) -
"Objects Examined Up/Hr" from summary where -
activity='EXPIRATION' and days (end_time) -days (start_time)=0
Thanks for any help.
Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- [ADSM-L] Sql assistance in tsm 6.2.2,
Lee, Gary D. <=
|
|
|