TSM - Help SELECT part 2

[girreis]

Dear,

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

Thank you for your attention,
Ramon

 

[rore]

select * from nodes

 

[sandeepkontham]

go through these commands for any sqlcommand

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

 

[girreis]

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

 

[rore]

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.

 

[rore]

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

 

[sandeepkontham]

Rore, I was just giving him overall idea so that he can check and make sql commands

 

[girreis]

Thanks, Rore.

 

[rore]

sandeepkontham, ok cool.