Database view containing EAM asset group code description

Owned by Knowledge Assistant
Mar 31, 2023
1 min read



Description of Issue

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



Context

  • Munis

  • SSRS reports

  • Crystal reports

  • Enterprise Asset Management



Cause

View database column overlay option is not available



Resolution

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



Additional Information