1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Need a script that displays NODE REPLICATION DETAILS in daily report

Discussion in 'Scripting' started by jquonce, Aug 22, 2012.

  1. jquonce

    jquonce New Member

    Joined:
    Jul 16, 2008
    Messages:
    25
    Likes Received:
    0
    Location:
    Watertown, NY
    I am looking for a script that I can add to the daily report with the details for NODE REPLICATIONs? Does anyone have one?

    Thanks in advance.
     
  2.  
  3. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,072
    Likes Received:
    269
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Replication?? What exactly do you mean by that?

    Or, de-duplication?
     
    Last edited: Aug 23, 2012
  4. jquonce

    jquonce New Member

    Joined:
    Jul 16, 2008
    Messages:
    25
    Likes Received:
    0
    Location:
    Watertown, NY
    We have TSM 6.3 and we are doing a NODE REPLICATION from one server to another server.
     
  5. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,072
    Likes Received:
    269
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Sorry, I don't have a TSM 6.3 environment to come up with the script.
     
  6. balkark

    balkark New Member

    Joined:
    May 12, 2007
    Messages:
    44
    Likes Received:
    2
    Give this a try....

    select node_name,fsname,comp_state,BKBYTES_REPLICATED/1024/1024/1024 as GB_REPLICATED,BKBYTES_TRANSFERRED/1024/1024/1024 as GB_TRANSFERED,date(start_time) as "Date",time(start_time) as "Start",time(end_time) as "End",timestampdiff (4, char(timestamp (end_time) - timestamp (start_time))) as DURATION_MINS from replicationview where start_time>current_timestamp-1 day
     
  7. bentman78

    bentman78 New Member

    Joined:
    Sep 12, 2005
    Messages:
    30
    Likes Received:
    0
    Is there a way to do this by nodegroup? I have my replication handled by nodegroups.
     

Share This Page