TSM client script (or command)

[tsmhelum]

Hi


Does anyone have a script or command that will display only windows clients, their os version (i.e. windows 2000, 2003 etc) and whether its 64bit or 32?


Thanks


TSM version 6.2.2

[moon-buddy]

Not pretty but here is a startng point:

SELECT node_name, platform_name, domain_name, CHAR(client_version)||'.'||CHAR(client_release)||' .'||CHAR(client_level)||'-'||CHAR(client_sublevel) as "TSM Client Version" FROM nodes where platform_name='WinNT'

[tsmhelum]

Ed thanks, I appreciate it the script helps a lot.