You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.
With xMatters, you'll never miss a beat.
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.