Search old update target Tivoli Remote Control

This query will identify all the targets with the old date of update, which should be to identify the target in question is no longer active:

SELECT LIVEPOINTS.HWKEY ,ASSET.COMPUTERNAME ,LIVEPOINTS.DOMAIN_NAME ,LIVEPOINTS.IP_ADDRESSES ,LIVEPOINTS.LOGGED_USER ,LIVEPOINTS.USER_LANGUAGE ,LIVEPOINTS.OS_NAME ,LIVEPOINTS.TIMEZONE ,LIVEPOINTS.TARGET_VERSION ,LIVEPOINTS.LAST_UPDATE  FROM ASSET.LIVEPOINTS LIVEPOINTS LEFT OUTER JOIN ASSET.ASSET ASSET ON LIVEPOINTS.HWKEY = ASSET.HWKEY WHERE LIVEPOINTS.LAST_UPDATE < ‘2011-11-01 00:00:01’

Search old update target Tivoli Remote Control

Leave a Reply

Your email address will not be published.