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.

Silly format question

Discussion in 'Command Line Administrator Client' started by cwilloug, Jul 14, 2010.

  1. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    So I'm now over one million session numbers in TSM, and have a format issue, its not a big thing, but how can I add spaces to the sess number colum so its all on one line?

    tsm: TSM>q sess

    Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name
    Number Method State Time Sent Recvd Type
    ------- ------ ------ ------ ------- ------- ----- -------- -------------------
    1,074,3 Tcp/Ip Run 0 S 988.0 K 105 Admin WinNT Cxxx
    29
    1,076,8 Tcp/Ip Run 0 S 6.7 K 347 Admin WinNT Cxxx
    54
    1,076,9 Tcp/Ip IdleW 33.1 M 1.2 K 134 Admin WinNT DOSxxxx
    13
    1,076,9 Tcp/Ip Run 0 S 120 196 Admin AIX Uxxxxx
    58
    1,076,9 Tcp/Ip IdleW 23 S 1.6 K 272 Node WinNT ESxxxxxx
    60
    1,076,9 Tcp/Ip Run 0 S 14.5 K 591 Node WinNT ESxxxxxx
    62
     
  2.  
  3. mikeymac

    mikeymac Moderator

    Joined:
    Jun 20, 2003
    Messages:
    907
    Likes Received:
    27
    Location:
    Syracuse, NY
    Don't think you can. Just cycle your TSM server when you have a free moment.
     
  4. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    That's not the answer I was looking for.... lol
     
  5. mikeatkc

    mikeatkc Senior Member

    Joined:
    Apr 24, 2007
    Messages:
    450
    Likes Received:
    4
    Location:
    United States
    Sounds a lot like a MS product :-/
     
  6. mikeymac

    mikeymac Moderator

    Joined:
    Jun 20, 2003
    Messages:
    907
    Likes Received:
    27
    Location:
    Syracuse, NY
    Alright, alright! :tongue:

    Well, you can do a query against the sessions table instead.

    SELECT SESSION_ID,COMMMETHOD,STATE,WAIT_SECONDS,BYTES_SENT,BYTES_RECEIVED,SESSION_TYPE,CLIENT_PLATFORM,CLIENT_NAME FROM SESSIONS

    Cut out the fields you don't think you need, and format the time and bytes fields so that they are easier to read.

    This query probably has just about everything I'd want:

    select session_id,state,wait_seconds,bytes_sent,bytes_received,client_name from sessions

    Stick that in a script, and run it when the mood strikes you.
     
  7. n9hmg

    n9hmg Senior Member

    Joined:
    Dec 18, 2006
    Messages:
    600
    Likes Received:
    13
    Occupation:
    unix admin
    Location:
    northern front-range Colorado, USA
    -tabdelimited on your dsmadmc commandline. Much more readable, and trivial to chop up in text processing.
     

Share This Page