Add Asset Description to Report

Hi All,

We have a simple Query to make a report for our Ipad.

But we have values that are added in the description field.

Could someone help us to add that field to our report ?

SELECT MAX("resource"."RESOURCENAME") AS "Asset Name", MAX("aaaUser"."FIRST_NAME") AS "User", MAX("productType"."COMPONENTTYPENAME") AS "Product Type", MAX("resFields"."UDF_CHAR3") AS "Extra Info" FROM "Resources" "resource" LEFT JOIN "ComponentDefinition" "product" ON "resource"."COMPONENTID"="product"."COMPONENTID" LEFT JOIN "ComponentType" "productType" ON "product"."COMPONENTTYPEID"="productType"."COMPONENTTYPEID" LEFT JOIN "ResourceOwner" "rOwner" ON "resource"."RESOURCEID"="rOwner"."RESOURCEID" LEFT JOIN "ResourceAssociation" "rToAsset" ON "rOwner"."RESOURCEOWNERID"="rToAsset"."RESOURCEOWNERID" LEFT JOIN "SDUser" "sdUser" ON "rOwner"."USERID"="sdUser"."USERID" LEFT JOIN "AaaUser" "aaaUser" ON "sdUser"."USERID"="aaaUser"."USER_ID" LEFT JOIN "Resource_Fields" "resFields" ON "resource"."RESOURCEID"="resFields"."RESOURCEID" WHERE ("resource"."RESOURCENAME" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'ipad%') GROUP BY "resource"."RESOURCEID"

Greetings,

David