Andrew21210
ADSM.ORG Member
- Joined
- Apr 10, 2008
- Messages
- 97
- Reaction score
- 2
- Points
- 0
I'm trying to massage a select statement in order to get all Windows 2008 nodes that are running TSM client 5.5.x.x with specific node names. I'm starting with this as a base but I don't seem to be getting anywhere.
select case -
when varchar(platform_name,20) || ' ' || cast(client_os_level as char(20)) ='WinNT 6.00' then 'WinNT 2008' -
when varchar(platform_name,20) || ' ' || cast(client_os_level as char(20)) ='WinNT 6.01' then 'WinNT 2008 -
else varchar(platform_name,20) || ' ' || cast(client_os_level as char(20)) -
end -
AS platform_name, -
cast(client_version as char(1)) || '.' || cast(client_release as char(1)) || '.' || cast(client_level as char(1)) || '.' || cast(client_sublevel as char(1)) as TSM_Version, count(distinct tcp_name) AS COUNT from nodes group by platform_name, client_os_level, client_version, client_release, client_level, client_sublevel -
order by 1 DESC,2 DESC
Can anyone give some insight as to how to get a list of specific node names?
select case -
when varchar(platform_name,20) || ' ' || cast(client_os_level as char(20)) ='WinNT 6.00' then 'WinNT 2008' -
when varchar(platform_name,20) || ' ' || cast(client_os_level as char(20)) ='WinNT 6.01' then 'WinNT 2008 -
else varchar(platform_name,20) || ' ' || cast(client_os_level as char(20)) -
end -
AS platform_name, -
cast(client_version as char(1)) || '.' || cast(client_release as char(1)) || '.' || cast(client_level as char(1)) || '.' || cast(client_sublevel as char(1)) as TSM_Version, count(distinct tcp_name) AS COUNT from nodes group by platform_name, client_os_level, client_version, client_release, client_level, client_sublevel -
order by 1 DESC,2 DESC
Can anyone give some insight as to how to get a list of specific node names?