ADSM-L

[ADSM-L] Sql assistance in tsm 6.2.2

2011-09-22 15:35:21
Subject: [ADSM-L] Sql assistance in tsm 6.2.2
From: "Lee, Gary D." <GLEE AT BSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 22 Sep 2011 15:28:32 -0400
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. <=