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 EMPLOYEE.FIRST + ' ' + EMPLOYEE.LAST AS NAME, CLIENT.NAME AS CLIENT, PROJECT.NAME AS PROJECT, TASK.NAME AS TASK, [GROUP].NAME AS TEAM, TRANS.DATE, CUSTOMVALUE.VALUE FROM PROJECT INNER JOIN TRANS ON PROJECT.ID = TRANS.PROJECT INNER JOIN TASK ON TRANS.TASK = TASK.ID INNER JOIN EMPLOYEE ON TRANS.EMPLOYEE = EMPLOYEE.ID INNER JOIN [GROUP] ON TRANS.[GROUP] = [GROUP].ID LEFT OUTER JOIN CUSTOM INNER JOIN CUSTOMVALUE ON CUSTOM.ID = CUSTOMVALUE.CUSTOM INNER JOIN CUSTOMTEMPLATE ON CUSTOM.CUSTOMTEMPLATE = CUSTOMTEMPLATE.ID ON PROJECT.ID = CUSTOM.LINKID AND TASK.ID = CUSTOM.LINKID LEFT OUTER JOIN CLIENT ON TRANS.PROJECT = CLIENT.ID WHERE (CUSTOMVALUE.VALUE IS NOT NULL) ORDER BY NAME
Join the community of 500,000 technology professionals and ask your questions.