Create new reference or choice field (u_ci_type) that provides a list of all CI classes

[cynlink1]

I am attempting to create a new reference or choice field (u_ci_type) that provides the user with a list of all CI classes. Once the u_ci_type field is populated, the configuration item list will be filtered based on the selection.

[Bert_c1]

You can try configuring the "configure item" field with a dependent field being u_ci_type. Like 'assigned_to' is defined on 'task' table that filters user based on the assignment_group value when creating or updating a record.

Seem you have not provided enough details to help further.

[cynlink1]

Hi,

I was experiencing difficulty figuring out how to set up the u_ci_type field to pull in all of the CI table names. However, I identified a solution that works. However, I am not sure it is the 'best practice' to reference the sys_db_object table. See screenshots.

[AshishKM]

Hello @cynlink1 ,

There is OOTB table which has all CI Class , Category & Subcategory details. You don't need to query on sys_db_object table instead use table [ cmdb_categories ] to list all CI Class type in "u_ci_type" field.