Hello,

I'm working to create a custom report with status of licenses: installed, purchaed, allocated, available... this is the query:

SELECT "softl"."SOFTWARENAME" AS "Software Name",
"softcomp"."COMPLIANCETYPE" AS "Compliance Type",
"swmfg"."NAME" AS "Manufacturer",
"scd"."INSTALLED" AS "Installed",
"scd"."PURCHASED" AS "Purchased",
"scd"."ALLOCATED" AS "Allocated",
"scd"."AVAILABLE" AS "Available"
FROM "SWComplianceDetails" "scd"
LEFT JOIN "SoftwareList" "softl" ON "scd"."SOFTWAREID"="softl"."SOFTWAREID"
LEFT JOIN "SoftwareManufacturer" "swmfg" ON "softl"."SWMANUFACTURERID"="swmfg"."SWMANUFACTURERID"
LEFT JOIN "SWComplianceType" "softcomp" ON "scd"."SWCOMPLIANCETYPEID"="softcomp"."SWCOMPLIANCETYPEID"
left join "scd" "softwareid" ON "softwareid"

But I want to include filed "by site". furthermore, I created a custom attributed named "label inventory", that match with the imported FA accounting purchased licensed.. and I don't know the data model stored this custom attibuted.

Software involved: Manage Engine Asset Explorer

Thanks for your support