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.

TSM - Help SELECT part 2

Discussion in 'Command Line Administrator Client' started by girreis, Mar 3, 2011.

  1. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    115
    Likes Received:
    1
    Dear,

    How do I list via SQL command data NAME OF CLIENT, CLIENT VERSION TSM and SO.

    Thank you for your attention,
    Ramon
     
  2.  
  3. rore

    rore Senior Member

    Joined:
    Nov 27, 2005
    Messages:
    642
    Likes Received:
    15
    Occupation:
    SysAdmin
    Location:
    Montreal, CA
    select * from nodes
     
  4. sandeepkontham

    sandeepkontham New Member

    Joined:
    Mar 14, 2009
    Messages:
    284
    Likes Received:
    3
    Occupation:
    Storage admin
    Location:
    Hyderabad,India
    go through these commands for any sqlcommand

    select * from syscat.tables
    select * from syscat.columns where tabname='TABLE_NAME'
     
  5. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    115
    Likes Received:
    1
    Thanks, Rore!

    But in this SELECT statement:
    SELECT node_name, varchar (client_version )||'.'|| varchar (client_release )||'.'|| varchar (client_level )||'.'|| varchar (client_sublevel) from nodes

    Listed are the NODE (Client) and the version of TSM, correct?
    How to include this same command to list the OS which corresponds to the NODE, without having to use the SELECT * FROM NODES?

    Thank you for your attention,
    Ramon
     
  6. rore

    rore Senior Member

    Joined:
    Nov 27, 2005
    Messages:
    642
    Likes Received:
    15
    Occupation:
    SysAdmin
    Location:
    Montreal, CA
    ???
    Those will not list the name of the client and client version.
     
  7. rore

    rore Senior Member

    Joined:
    Nov 27, 2005
    Messages:
    642
    Likes Received:
    15
    Occupation:
    SysAdmin
    Location:
    Montreal, CA
    SELECT node_name, varchar (client_version )||'.'|| varchar (client_release )||'.'|| varchar (client_level )||'.'|| varchar (client_sublevel),platform_name from nodes
     
  8. sandeepkontham

    sandeepkontham New Member

    Joined:
    Mar 14, 2009
    Messages:
    284
    Likes Received:
    3
    Occupation:
    Storage admin
    Location:
    Hyderabad,India
    Rore, I was just giving him overall idea so that he can check and make sql commands
     
  9. girreis

    girreis New Member

    Joined:
    Feb 11, 2011
    Messages:
    115
    Likes Received:
    1
    Thanks, Rore.
     
  10. rore

    rore Senior Member

    Joined:
    Nov 27, 2005
    Messages:
    642
    Likes Received:
    15
    Occupation:
    SysAdmin
    Location:
    Montreal, CA
    sandeepkontham, ok cool.
     

Share This Page