Missing out-of-the-box fields (sys_created, sys_created_on...) on table

[peter_repan]

Hi all,

we are facing curious issue: for some reason we are missing out of the box fields like sys_created, sys_created_by, sys_updated, sys_updated_by (+ other "sys_"... fields) on table alm_hardware.

Don't know where they gone. On wiki is "Base system fields cannot be deleted. Additionally, any missing base system fields are recreated when the instance is upgraded."

My question is - does anyone idea what could happened or how to fix it (without waiting for a upgrade)?

Thank you

[Mike Allen]

No, Assets are like Config data.   The data sits on the parent table (alm_asset or cmdb_ci) and the classes extend from there, where specific attributes are added.   But all the base data resides on the base table.

[Mike Allen]

Even if you look in the dictionary of incident, you don't see the sys_ tables, because they are on task:

[peter_repan]

But when I check "Show XML" on the incident, I can see sys_created, sys_updated, sys_* fields.

In XML of alm_hardware not:

[Mike Allen]

That's weird.   My XML has all of it:

[peter_repan]

And that's my question What happened to my fields & how to fix it?