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 g.Agency,g.Goal,o.Objective,p.PI,P.Method,a.[ActivityName],P.[ProjectedHours],a.Data, s.ProgressSetback from tblOrgGoals G LEFT Join tblOrgObjectives O on G.GoalID = O.GoalID LEFT Join tblOrgActivities A on O.ObjectiveID = A.ObjectiveID LEFT Join tblOrgMonthlyProgressSetbacks S on A.ActivityID = s.activityID LEFT Join tblOrgPI P on P.ActivityID = A.ActivityID Where G.AgencyID = 74 And S.MonthlyID = 4 order by G.Agency,G.Goal