How to show extended table fields in a UI view?

[Michael H1]

Here's a question that I may not be searching correctly because I have been unable to find an answer, or I am not using best practices:

I have two tables that I am working with, the Hardware (alm_hardware) table and the Computer (cmdb_ci_computer) table. I have created fields for an upcoming Intune integration that I am working on so that information such as Compliance State, Last Check In, and Sync Enrolled Date/Time are populated.

These fields do not need to exist on the base CI table, so I have created them on the Computer table. I then added them to our Hardware table and created business rules to have the fields synced across the tables on their associated records.

But then I had the thought, does it really make sense to have these fields on the Hardware table? We store monitors, webcams, and other peripheral devices that of course are not in Intune, and it seems like a waste of a field.

Is there a way to have extended table fields display in a UI form view/layout? I see that "Configuration Item" is an option to grab fields from and we've been using it fine. Is there a way to grab fields from the extended "Computer" table in a UI view, or no? I don't see a way to accomplish this but it seems unnecessary to have created fields on the Hardware table if I can simply display the Computer table fields for when a Computer asset record is being viewed on the Hardware table.

[Ratnakar7 · Accepted solution]

Hi @Michael H1 ,

Yes, it is possible to display extended table fields in a UI view/layout. One way to achieve this is by creating a relationship between the two tables, in this case, Hardware and Computer. Once the relationship is established, you can use the reference qualifier to restrict the records to only display records from the Computer table.

The reference qualifier could be something like:

sys_class_name=cmdb_ci_computer^u_intune_compliance_stateISNOTEMPTY

Thank you!

Ratnakar

[Michael H1]

This ended up being what I performed.

For all Hardware (alm_hardware table) records of type Computer, I updated a reference field I created titled "Computer Record" to the appropriate/equivalent Computer (cmdb_ci_computer table) record.

Not that it is relevant to this post, but I have populated this for all Computer type records on the Hardware table as we intend to have a Jamf integration set up soon, too, so will need to display similar fields only applicable to Computer Hardware records. This is a really simple to implement solution that allows us to keep our Hardware table relatively clean of fields that don't need to be on all records.

Thanks for the answer, @Ratnakar7.