Database view containing EAM asset group code description

Client needs a TRS view containing asset group code description for a custom report

• Munis

• SSRS reports

• Crystal reports

• Enterprise Asset Management

View database column overlay option is not available

Asset group code description is available in table AssetManagement.AssetGroupCodes. The following sample SQL query shows how to obtain the description for a given asset code

SELECT DISTINCT
A.a_code AS AssetCode, 
E.wmae_type_id, 
G.Code AS GroupCode, 
G.ShortDescription,   
G.[Description], 
G.AssetCategoryCode 
FROM wm_assets AS A LEFT JOIN wmasteqp AS E ON
E.wmae_hdr_id = A.a_hdr_id
LEFT JOIN AssetManagement.AssetGroupCodes AS G
ON E.wmae_type_id = G.Id
ORDER BY a_code