Database view for custom data in Asset Registry

Client wants to be able to write a custom report with the custom data found in the Asset Registry

• Munis 2018.1 and later versions

• SSRS reports

• Crystal reports

• SaaS, Tyler-hosted clients

• OnPrem, Self-hosted clients

• Asset Registry

The view database column overlay shows custom data fields as derived.

This custom data is located in the view wm_user_data.  Replace XXXX in the following query with the asset code to retrieve custom data for that specific asset code:

select distinct a_code,

uf_label,

ud_data

from wm_assets

inner join wm_user_data

on a_hdr_id = a_header_id where uf_prog_type='A'

and a_code='XXXX'