Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!