Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Apr 2004
    Location
    Vienna
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Script doesn't work since TSM V6.2 is used

    /* -----------------------------------------------------------------*/
    /* Script Name: back_single */
    /* Parameter: script <hours> <Nodename> */
    /* Description: Displays nodes and their amount of files and MBs. */
    /* -----------------------------------------------------------------*/
    select Entity,Successful,Bytes/1024/1024 as "MBs",date(start_time)as "START Date",time(START_TIME) as "Time",Date(END_TIME) as "END DATE",time(end_time) as "Time",Examined,Affected,Failed from summary -
    where activity in ('BACKUP','ARCHIVE') and cast((current_timestamp-start_time)hours as decimal(8,0)) < $1 and entity='$2' order by Entity



    This showed me the backups of node ($2) in the last ($1) hours.
    No it shows me ALL backups instead of the last $1 hours.
    Any idea
    Thx, Hannes

  2. #2
    Member
    Join Date
    Oct 2003
    Location
    Grevenbroich / Germany
    Posts
    24
    Thanks
    1
    Thanked 4 Times in 4 Posts

    Default

    Hi schuhb,

    try this :

    select Entity,Successful,Bytes/1024/1024 as "MBs",date(start_time)as "START Date",time(START_TIME) as "Time",Date(END_TIME) as "END DATE",time(end_time) as "Time",Examined,Affected,Failed from summary where activity in ('BACKUP','ARCHIVE') and cast(hour(current_timestamp-start_time) as decimal(8,0)) < $1 and entity='$2' order by Entity

    regards

    Ugur

  3. #3
    Member
    Join Date
    Apr 2004
    Location
    Vienna
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Sorry, for the long delay....same outcome

  4. #4
    Member
    Join Date
    Jun 2012
    Posts
    57
    Thanks
    3
    Thanked 6 Times in 6 Posts

    Default

    select -
    entity, -
    date(start_time) -
    from -
    summary -
    where -
    activity in ('BACKUP','ARCHIVE') -
    and entity='$2' -
    and start_time>current_timestamp-$1 hours

Similar Threads

  1. TSM for VE - vCenter Plugin doesn't work
    By schnupfy in forum VMWare / Virtual Machine
    Replies: 22
    Last Post: 05-16-2012, 04:45 AM
  2. Replies: 2
    Last Post: 01-27-2011, 10:12 PM
  3. ANS4987E Serialization doesn't work?
    By CarlosJ in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 03-16-2009, 02:49 PM
  4. TSM Server1 service doesn't work.
    By Locum in forum TSM Server
    Replies: 1
    Last Post: 03-07-2006, 08:35 PM
  5. LAN Free doesn't work !
    By hokwan in forum Tape / Media Library
    Replies: 1
    Last Post: 01-30-2003, 10:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •