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 s.id sId, l.id lId, count(c.ID) cCount, DATEPART (week,c.datetimereported) cReportedWeek, CASE WHEN l.liftshortname is Null THEN ' ** Site Level ** ' ELSE l.liftshortname END lLift FROM site s LEFT JOIN job j ON s.id = j.siteid INNER JOIN callout c ON j.id = c.jobid INNER JOIN jobline jl ON j.id = jl.jobid LEFT JOIN lift l ON jl.liftid = l.id WHERE ( c.datetimereported BETWEEN '01/01/2010' AND '12/12/2010' ) AND ( s.id IN (SELECT id FROM site s WHERE ( contractid = 3005 )) ) group by DATEPART (week,c.datetimereported), s.id, l.id, l.liftshortname
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.