List Collector field with cmdb_ci table taking too long to load data.

[Namita_Snow]

Hi everyone!

I'm currently working on a requirement, where we need to show cmdb_ci data in a list collector variable. I'm using on change client script and script include to filter the data based on the choice selection in another variable.

But currently the variable with cmdb_ci data takes more than one minute to load the data.

Please let me if there is any way to improve the data loading.

Thanks in Advance!

[RaghavSh]

Optimise your queries based in class, operational/install status, device type or name is not empty.

I don’t think there are any scenarios where entire cmdb_ci table records are required.