Reference Qualifier for Affected CI is not working as expected

[Saib1]

Hi 

We have requirement to query the affected ci in incident table. when i click on the Fill button , I just called the reference qualifier by querying from Script Include . it was taking to long to query the data with filter and populated the CI's. 

We have to query the data from 20 classed based on the below condition . when i applied the query it has 35000 records showing and takes to long to show up in Affected CI field.

Filter condition need to be applied on this below.

Is there any way that we can get the query quicker ?

[Nishu Saini · Accepted solution]

Check your last line return 'operational_status=1^ install_status=1^sys_class_name=u_facilities_change_ci_s^ORsys_class_name=u_cmdb_template_affected_ci' So on ... You can check if alternate query could be small class should not be x , y ,z instead of classes should be x,yz in case the classes are less in tht case.

[Saib1]

Hi Nishu,

I just simplified my code like below instead of 

and it returns 31,000 records and taking time 15 sec to get the record

return 'operational_status=1^install_status=1^environment=Production^sys_class_name=cmdb_ci_service^NQoperational_status=1^install_status=1^environment=Production^sys_class_name=cmdb_ci_service_discovered^NQoperational_status=1^install_status=1^sys_class_name=u_cmdb_ci_ceep^NQoperational_status=1^install_status=1^environment=Production^sys_class_name=cmdb_ci_server^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_netgear^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_lb^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_lb_bigip^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_mainframe_hardware^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_appl_ibm_cics^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_mainframe_lpar^NQoperational_status=1^install_status=1^sys_class_name=u_cmdb_ci_storage_array^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_san_fabric^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_hardware^NQoperational_status=1^ref_cmdb_ci_kubernetes_statefulset.install_status=1^sys_class_name=cmdb_ci_app_server_websphere^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_appl_ibm_wmq^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_datacenter^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_dns_alias^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_config_file_tracked^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_computer^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_comm^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_printer^NQoperational_status=1^install_status=1^sys_class_name=u_tcr^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_scanner^NQref_cmdb_ci_spkg.u_app_bible=true^sys_class_name=cmdb_ci_spkg^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_kubernetes_service^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_kubernetes_node^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_kubernetes_cluster^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_kubernetes_pod^NQoperational_status=1^install_status=1^sys_class_name=u_cmdb_template_affected_ci^NQoperational_status=1^sys_class_name=u_facilities_change_ci_s^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_database^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_db_instance^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_oracle_database^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_win_cluster^NQoperational_status=1^install_status=1^sys_class_name=cmdb_ci_win_cluster_resource';

[Nishu Saini]

Hi,

Make sure your query is correct. I guess this is more optimized. Hope it is faster than earlier. If you want more flexibility you can make a system property store the classes name there and access in the script include to make a query. It will be easy in the future to add and remove classes in the property.

Please mark helpful/correct If my suggestion is useful.