CI field has sysparm_target=change_request.cmdb_ci automatically in filter, can't see all CIs

[Abbottronix]

I have 2246 CIs in my CMDB, but when I go to select a CI from the Configuration Item field on a change, incident or problem form, it only gives me 354 CIs to choose from. I noticed that the URL for the pop up select box that appears has a sysparm_target filter in its URL. For change requests it's sysparm_target=change_request.cmdb_ci, for incident forms it's sysparm_target=incident.cmdb_ci, etc. If I remove this from the URL, I get to see all 2246 CIs. The best of my understanding is that the sysparm_target filter is targeting CIs that are already related to records. But if that's correct, I can't figure out why the default filter would restrict the number of the CIs I can reference on a form, to CIs that are referenced on other forms. I checked a personal instance, and the filter is the same there, so it seems to be an OOTB thing. We're using the Washington version.

[Ahmmed Ali]

Hello @Abbottronix 

The parameter sysparm_target=change_request.cmdb_ci indicates that the record you select in the popup will be populated in change_request table and cmdb_ci field. It has nothing to do with filter.

For filter, you need to check if any reference qualifier is configured for CI field. You can open the change form, right lick on Configuration item field and select configure dictionary. Here you can see the filter applied in reference qualifier field. Also check if there are any dictionary override for change and incident table (in the same form, you have dictionary override related list, you can filter out based on table).

If there are any override record, then for that table override value will be applied, if no records then default dictionary form value will be applied.

Thank you,

Ali

[Nishant8 · Accepted solution]

Hello @Abbottronix, I assume that you don't have Domain separation enabled in your instance. Can you please verify couple of suggestions and share the outcome?

- Verify whether Company field on CHG/INC/PRB is auto populated with any value? Company field is not available on the task forms OOB, but you can personalize the form to show the same field or for now you can verify whether URL (where you found sysparm_target=incident.cmdb_ci, etc) contains any value for 'sysparm_dependent'? Basically, CIs list is dependent on Company field.

- Other thing you can verify is Principal Class - since list is showing such a small number, probability seems low that these many classes are marked as Principal, but just to be safer side asking.

[Abbottronix]

Looks like it was the Principal Class, thank you for your help