Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT LID.LID, PERSON.HRLN, PERSON.HRFN, PERSON.HRMI, HA.STREETLINE1, HA.STREETLINE2, HA.CITY, HA.STATE, HA.ZIPCODE, HA.COUNTRY, L1.DESCRIPTION, EE.HRDEPTDESC, EE.HRDEPTID, EMP2.CONFIG1, EMP2.CONFIG2, EMP2.BCT_GROUP, EMP2.BCT_COORDINATOR, PH.PHONENUM FROM LID LID, PERSON PERSON, LOCATION L1, LID_LOC L2, HOME_ADDRESS HA, EMP2 EMP2, EMPLOYEE EE, PHONE PH WHERE LID.LID=PERSON.LID AND HA.PERSONID = PERSON.PERSONID AND EMP2.PERSONID = PERSON.PERSONID AND EE.PERSONID = PERSON.PERSONID AND PH.LID = LID.LID AND PH.PRIMARY_PHONE = 'Y' AND LID.LID_TYPE='PERSON' AND LID.STATUS = 'A' AND L1.LOCATIONID=L2.LOCATIONID AND L2.PERSONID=PERSON.PERSONID AND ((PERSON.ENTITYID = 'LWS' AND L1.LOCATIONID NOT IN (10551,10695, 10698)) OR (PERSON.ENTITYID = 'LHT' AND L1.LOCATIONID IN (10539,10508,10509,10510,10511))) ORDER BY PERSON.HRLN
Join the community of 500,000 technology professionals and ask your questions.