select
ELN.NodeName as ClientName,
ELN.AgentGUID,
AH.ComputerName as HandlerName,
AH.LastKnownTCPIP as HandlerIP,
DCWQ.Source as DCRequest,
DCWQAttempts.LastDeliveryAttempt as DCLastAttemptTime,
DCWQ.RetryDelay as RetryDelaySeconds,
DCWQAttempts.RetriesRemaining,
DCWQ.ExpireTime as DCExpireTime
from
EPOLeafNode as ELN, EPOAgentHandlerDataChannelWQMT as DCWQ,
EPOAgentHandlerDataChannelWQAttemptsMT as DCWQAttempts, EPORegisteredApacheServers as AH
where
DCWQ.AutoID = DCWQAttempts.ParentID
and DCWQ.Target = ELN.AutoID
and DCWQAttempts.AgentHandlerId = AH.AutoID
and ELN.NodeName = '
'
と書かれている箇所は実際にクエリを実行するシステムに置き換えてください。 例えば、TEST という名前のシステムにクエリを実行する場合、クエリの最後の行をこのようにします: ELN.NodeName = 'TEST'