Differences between alm_asset and alm_hardware

pjhmc2348
Kilo Guru

‎04-06-2021 07:43 AM

When I query the alm_hardware table for State/Substate, I do not see the same asset Substates that I do when I make the same query in alm_asset. 

Can someone tell me why I do not see the same data?

Below are Substates from alm_asset.

find_real_file.png

Below are Substates from alm_hardware

find_real_file.png

Preview file
21 KB
Preview file
6 KB
0 Helpfuls
  • 2,508 Views
1 REPLY 1

Alikutty A
Tera Sage

‎04-06-2021 09:18 AM

 

Hi,

It seems like some configuration has been done in your instance and dependency on sub state is removed from the base alm_asset table and it has been overriden on the child alm_hardware table. 

Can you check if substate field is dependent on the state field? and if it has a dictionary override?