SELECT max(resgrp.GROUPNAME) AS "Group Name",
       MAX(resource.RESOURCENAME) AS "Asset Name",
       MAX(state.DISPLAYSTATE) AS "Asset State",
       MAX(rCategory.CATEGORY) AS "Asset Category",
       MAX(product.COMPONENTNAME) AS "Product",
       MAX(productType.COMPONENTTYPENAME) AS "Product Type",
       MAX(aaaUser.FIRST_NAME) AS "User" FROM Resources RESOURCE
LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID
LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID
LEFT JOIN ResourceCategory rCategory ON productType.RESOURCECATEGORYID=rCategory.RESOURCECATEGORYID
LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID
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 StaticGroup stgrp ON stgrp.RESOURCEID = resource.RESOURCEID
LEFT JOIN ResourceGroup resgrp ON resgrp.GROUPID = stgrp.GROUPID
GROUP BY resource.RESOURCEID