I'd like make a report from workorders adding company columm for any case.

I have this Query for Company:

SELECT people.attribute_1201 "Company",

count(wo.WORKORDERID) "count" FROM WorkOrder wo 

LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID 

LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID 

Left join people on sdu.ciid=people.ciid  WHERE (wo.ISPARENT='1') group by people.attribute_1201 workorders:

And for WorkOrders:

SELECT wo.WORKORDERID AS "ID de la solicitud", qd.QUEUENAME AS "Grupo", aau.FIRST_NAME AS "Solicitante", dpt.DEPTNAME AS "Departamento", cd.CATEGORYNAME AS "Categoría", wo.TITLE AS "Asunto", cri.FIRST_NAME AS "Creado por", ti.FIRST_NAME AS "Técnico", wotodesc.FULLDESCRIPTION AS "Descripción", sdo.NAME AS "Sitio", rcode.NAME AS "Código de cierre de solicitud", std.STATUSNAME AS "Estado de solicitud", std.ISPENDING AS "Estado pendiente", wof.UDF_CHAR1 AS "UN" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN SDUser crd ON wo.CREATEDBYID=crd.USERID LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN RequestClosureCode rcode ON wos.CLOSURECODEID=rcode.CLOSURECODEID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE (wo.ISPARENT='1') limit 5000

Regards