TSm client version information required

[asifpanjwani]

team,

i need just help recently my boss giving me a task about please find all tsm client version , client type either TDP or BA and node name I HAVE 100+ server with tsm client install with different version, i need help is there any query i giving to TSM than they gave me complete information of all tsm client version with client type and node i have limited time for this task.


Regards

Asif Panjwani

 

[domino]

try

select server_name as "TSM_server",tcp_name as "Host",node_name as "Nodename ", PLATFORM_NAME || ' ' || cast(CLIENT_OS_LEVEL as char(30)) as "OS_Version ", cast(client_version as char) || '.' || cast(client_release as char) || '.' || cast(client_level as char) || '.' || cast(client_sublevel as char(2)) as TSM_Version,day(current_timestamp-lastacc_time) AS L_Acc from nodes, status where nodetype='CLIENT'

 

[asifpanjwani]

thanks but how can i apply this

 

[domino]

dsmadmc -se=<server> -id=<admin> -pa=<password> -comma -dataonly=yes -out=nodes.tsm "select server_name,tcp_name,node_name,platform_name,client_os_level,client_version,client_release,client_level,client_sublevel,day(current_timestamp-lastacc_time) from nodes, status where nodetype='CLIENT'"

 

[GregE]

......or login to TSM server and run directly from TSM command line............ starting with "select...."