Hi all,
I've created a database view and im seeing some strange behaviour maybe someone here knows whats going on. The database view is actually working fine but its not showing data in two fields that do have data on the acutal record.
The view consists out of three tables metric_instance/alm_hardware/sys_user . the metric is a duration metric on the assigned to field of the asset and the database view ties the tables together based on the metric ID and value / field_value.
From the alm_hardware table I want to see the display_name / install_state / substate / asset_tag and serial_number. The first 3 are showing just fine but the serial_number and asset_tag are blank in the database view.
Some extra info:
- the fields have been added to the view fields.
- i'm admin so I have the correct permisions.
- no issues with fields from the other tables or the other fields from the alm_hardware table.
- the actual records do containt data in those fields.
- i've tried removing and adding the fields etc.
The goal is that our IT staff can see what assets have been assigned to a user in the past and to what user an asset has been assigned to in the past.
Regards,
Matthijs
