Hi
i'm using this custom report and i would like to show the JOB TITLE of the user when i run the report, because i cant see the JOB TITLE in Available Columns so that i can move it to Display Columns.... any one can help please.
SELECT resUser.FIRST_NAME AS "User", resDept.DEPTNAME AS "Department", ci.CINAME AS "CI Name", baseci.ATTRIBUTE_301 AS "IMEI", baseci.ATTRIBUTE_304 AS "Sim Type", resLoc.LOCATION AS "Location", civendor.NAME AS "Vendor", citype.TYPENAME AS "CI Type" FROM CIType_301 citype_301 LEFT JOIN Resources cires ON citype_301.CIID=cires.CIID LEFT JOIN BaseElement baseci ON cires.CIID=baseci.CIID LEFT JOIN CI ci ON baseci.CIID=ci.CIID LEFT JOIN CIType citype ON ci.CITYPEID=citype.TYPEID LEFT JOIN SDOrganization civendor ON cires.VENDORID=civendor.ORG_ID LEFT JOIN ResourceOwner resOwn ON cires.RESOURCEID=resOwn.RESOURCEID LEFT JOIN DepartmentDefinition resDept ON resOwn.DEPTID=resDept.DEPTID LEFT JOIN AaaUser resUser ON resOwn.USERID=resUser.USER_ID LEFT JOIN ResourceLocation resLoc ON cires.RESOURCEID=resLoc.RESOURCEID WHERE (cires.CIID IS NOT NULL)
Thanks,,,