Do you need to test one of the monitoring agents? Follow these steps to create a test script that you can execute against your new agent.

Http SSL Services

SELECT 'httpAgent -d 1 -t "' || b.description || '" ' || 
       h.hostname || ' ' || h.ipaddress || ' ' || h.transaction || 
       ' ' || h.port || ' "' || h.path1 || '" "' || h.accept_string ||
       '" "' || h.reject_string || '" Y'
FROM httpservice h, browsers b, subservice ss
WHERE h.SSL='Y'
AND h.browserid=b.browserid
AND h.serviceid= ss.serviceid
AND ss.expiredate > sysdate

Http NON-SSL Services and NOT in 10.x.x.x address space

SELECT 'httpAgent -t "' || b.description || '" ' ||
       h.hostname || ' ' || h.ipaddress || ' ' || h.transaction ||
       ' ' || h.port || ' "' || h.path1 || '" "' || h.accept_string ||
       '" "' || h.reject_string || '" ' || h.SSL
FROM httpservice h, browsers b, subservice ss
WHERE h.SSL != 'Y'
AND h.browserid=b.browserid
AND h.serviceid= ss.serviceid
AND h.ipaddress not like '10.%'
AND ss.expiredate > sysdate

EMail Services

  1  SELECT 'emailAgent -t "' || e.ipaddress  || '" ' || e.email || ' ' || sl.dns
  2  FROM emailservice e, subservice ss, servicelist sl
  3  WHERE e.serviceid= ss.serviceid
  4  AND ss.expiredate > sysdate
  5* AND e.serviceid=sl.serviceid

Tester Notes (last edited 2006-10-06 15:45:13 by mark)