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.
Migration.AccessObjectsInEffect ( AccessObjectID char(8) not null, InEffect datetime not null ) Vector.EmployerSettings ( AccessObjectID PK char(8) not null, RandomTestingDayOfMonth tinyint not null, Logged datetime not null )
Select ES.*, I.* From Vector.EmployerSettings ES Full Outer Join Migration.AccessObjectInEffect I on I.AccessObjectID = ES.AccessObjectID and I.InEffect < GetDate() Where ES.AccessObjectID is null or I.AccessObjectID is null
AccessObjectID RandomTestingDayOfMonth Logged AccessObjectID InEffect NULL NULL NULL AO999999 2013-03-13 12:34:17.000
Select ES.*, I.* From Vector.EmployerSettings ES Full Outer Join ( Select * From Migration.AccessObjectInEffect Where InEffect < GetDate() ) I on I.AccessObjectID = ES.AccessObjectID Where ES.AccessObjectID is null or I.AccessObjectID is null