Results 1 to 9 of 9
  1. #1
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default TSM - Help SELECT part 2

    Dear,

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

    Thank you for your attention,
    Ramon

  2. #2
    Senior Member rore's Avatar
    Join Date
    Nov 2005
    Location
    Montreal, CA
    Posts
    637
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    select * from nodes

  3. #3
    Member sandeepkontham's Avatar
    Join Date
    Mar 2009
    Location
    Hyderabad,India
    Posts
    284
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    go through these commands for any sqlcommand

    select * from syscat.tables
    select * from syscat.columns where tabname='TABLE_NAME'
    *Everybody loves TSM (if understood )
    Sandeep

  4. #4
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    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

  5. #5
    Senior Member rore's Avatar
    Join Date
    Nov 2005
    Location
    Montreal, CA
    Posts
    637
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    Quote Originally Posted by sandeepkontham View Post
    go through these commands for any sqlcommand

    select * from syscat.tables
    select * from syscat.columns where tabname='TABLE_NAME'
    ???
    Those will not list the name of the client and client version.

  6. #6
    Senior Member rore's Avatar
    Join Date
    Nov 2005
    Location
    Montreal, CA
    Posts
    637
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    Quote Originally Posted by girreis View Post
    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
    SELECT node_name, varchar (client_version )||'.'|| varchar (client_release )||'.'|| varchar (client_level )||'.'|| varchar (client_sublevel),platform_name from nodes

  7. #7
    Member sandeepkontham's Avatar
    Join Date
    Mar 2009
    Location
    Hyderabad,India
    Posts
    284
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    Rore, I was just giving him overall idea so that he can check and make sql commands
    *Everybody loves TSM (if understood )
    Sandeep

  8. #8
    Member
    Join Date
    Feb 2011
    Posts
    97
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    Thanks, Rore.

  9. #9
    Senior Member rore's Avatar
    Join Date
    Nov 2005
    Location
    Montreal, CA
    Posts
    637
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    sandeepkontham, ok cool.

Similar Threads

  1. Does TSM for ERP is a part of TSM for database ?
    By hungng89 in forum TSM Client
    Replies: 1
    Last Post: 07-29-2010, 03:44 AM
  2. TSM 5.4 Database Conversion - Part 2
    By gmoores11 in forum TSM Server
    Replies: 1
    Last Post: 05-08-2008, 09:08 AM
  3. Thanx All Part II
    By Harry_Redl in forum Training and Certification
    Replies: 4
    Last Post: 07-13-2004, 05:37 AM
  4. Two part question :-)
    By mikle in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 05-26-2004, 09:54 AM
  5. Replies: 0
    Last Post: 07-23-2003, 01:08 PM

Posting Permissions

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