38 lines
1.4 KiB
SQL
38 lines
1.4 KiB
SQL
SELECT DISTINCT(assyst_usr_b.assyst_usr_n) AS "DBA Name",
|
|
COUNT(*) "Total Closed Calls"
|
|
FROM incident ,
|
|
product ,
|
|
item item_a ,
|
|
serv_dept serv_dept_b ,
|
|
assyst_usr assyst_usr_b,
|
|
usr usr_b ,
|
|
bldng_room ,
|
|
inc_cat inc_cat_a ,
|
|
inc_serious ,
|
|
supplier ,
|
|
hplan_head hplan_head_a,
|
|
inc_data
|
|
WHERE incident.item_id = item_a.item_id
|
|
AND item_a.product_id = product.product_id
|
|
AND incident.ass_usr_id = assyst_usr_b.assyst_usr_id
|
|
AND incident.ass_svd_id = serv_dept_b.serv_dept_id
|
|
AND incident.aff_usr_id = usr_b.usr_id
|
|
AND incident.inc_cat_id = inc_cat_a.inc_cat_id
|
|
AND incident.inc_serious_id = inc_serious.inc_serious_id
|
|
AND incident.ass_supp_id = supplier.supplier_id
|
|
AND incident.bldng_room_id = bldng_room.bldng_room_id
|
|
AND incident.hplan_head_id = hplan_head_a.hplan_head_id
|
|
AND incident.incident_id = inc_data.incident_id
|
|
AND (incident.incident_id >9999999
|
|
AND inc_data.u_num2 =0
|
|
OR incident.incident_id >0
|
|
AND incident.incident_id <5000000
|
|
OR incident.incident_id >4999999
|
|
AND incident.incident_id <10000000
|
|
OR (incident.incident_id >9999999
|
|
AND inc_data.u_num2 >0))
|
|
AND (incident.inc_status ='c' )
|
|
AND incident.ass_svd_id IN(16)
|
|
AND incident.inc_close_date > GETDATE()-29
|
|
GROUP BY (assyst_usr_b.assyst_usr_n)
|
|
ORDER BY "Total Closed Calls" DESC |