1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

TSM - Help SELECT part 2

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

  1. girreis

    girreis ADSM.ORG Member

    Joined:
    Feb 11, 2011
    Messages:
    118
    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 ADSM.ORG Senior Member

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

    sandeepkontham ADSM.ORG 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 ADSM.ORG Member

    Joined:
    Feb 11, 2011
    Messages:
    118
    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 ADSM.ORG 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 ADSM.ORG 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 ADSM.ORG 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 ADSM.ORG Member

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

    rore ADSM.ORG Senior Member

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

Share This Page