Operation Details
Description: Returns list of target systems for the given target system service name and record status.
Sterotype: nsmulti
SQL 
SELECT
  TargetSystem.systemID,
  TargetSystem.systemName
INTO
  :systemID,
  :systemName
FROM
  TargetSystem,
  TargetSystemService 
WHERE TargetSystem.systemID = TargetSystemService.systemID 
  AND TargetSystemService.name = :name
  AND TargetSystem.status = :status
  AND TargetSystemService.status = :status
  ORDER BY TargetSystem.systemName DESC