Need number of record for all tables with name containing "cmdb"

shessdri · ‎12-07-2023

Hi Team,

I have a requirement to get the records corresponding to each table containing cmdb in name

As in I have 1400 tables whose name contains cmdb, I want info for each table separately , like how many records each table is having.
Can anyone help me with the code OR filter corresponding to this.

Thanks.

Shamma Negi · ‎12-07-2023

var tables = [];

var getTables = new GlideRecord('sys_db_object');
getTables.addEncodedQuery('nameLIKEcmdb');
getTables.query();
while(getTables.next()){
tables.push(getTables.name.toString());
}

gs.log(tables.toString())l

gs.log("Table length " +tables.length);

for(var i=0;i<tables.length;i++)
{
var glideEachTable = new GlideAggregate(tables[i]);
glideEachTable.query();
while(glideEachTable.next()){
var rowCount = glideEachTable.getRowCount();
}
gs.log(rowCount);

}

Result as below:

*** Script: cmdb_ci_db_mssql_server,cmdb_ci_esx_server,cmdb_ci_storage_node,cmdb_rel_user_type,cmdb_ci_nat_gateway,cmdb_ire_incomplete_payloads,cmdb_ci_hyper_v_instance,cmdb_ci_endpoint_dctm_job,cmdb_dependent_ci_extra_rels_config,cmdb_qb_result_base,cmdb_ci_network_acl,cmdb_ci_cloud_webserver,cmdb_ci_endpoint_rabbitmq,cmdb_ci_endpoint_jms_flow,cmdb_ci_appl_doc_brava_server,cmdb_ci_appl_active_directory,cmdb_ci_cisco_apic,cmdb_ci_service_auto,cmdb_ci_lb_ckstickinesspolicy,cmdb_ci_endpoint_weblogic_module,cmdb_ci_vm_template,cmdb_service_model_lifecycle,cmdb_ci_endpoint_postgresql,cmdb_ci_directory_iifp,cmdb_ci_endpoint_obj_cms_srv,cmdb_ci_storage_eff_template,cmdb_ci_storage_server,cmdb_ci_san_connection,cmdb_ci_docker_image_tag,cmdb_ci_plotter,cmdb_ci_db_syb_instance,cmdb_ci_lb_isa,cmdb_ci_directory_ha,cmdb_ci_storage_device,cmdb_dynamic_ire_feature,cmdb_ci_appl_delivery_controler,cmdb_ire_reclassification_restriction,cmdb_ci_netapp_svm,cmdb_ci_epic_agent,cmdb_ci_firewall_network,cmdb_ci_endpoint_vpg,cmdb_ci_appl_weblogic_lb,cmdb_ci_db_mongodb_instance,cmdb_data_management_policy_runtime_attributes,cmdb_data_management_task_to_document,cmdb_ci_network_host,cmdb_ci_ibm_zos_server,cmdb_ci_appl_ora_oacore,cmdb_ci_ats_power_eq,cmdb_ci_db_mysql_catalog,cmdb_ci_db_mssql_reporting,cmdb_ci_hvac,sn_cmdb_ws_attestation_task_state,cmdb_ci_aws_datacenter,cmdb_ci_appl_citrix_app,cmdb_ci_appl_sap_ascs,cmdb_lb_vlan_interface,cmdb_ci_san_disk,cmdb_view,cmdb_ci_perf_template,cmdb_ci_linux_server,cmdb_policy_ci_exclusion_list,cmdb_ci_appl_rabbitmq_queue,cmdb_business_rule_exclusions,cmdb_ci_directory_server,cmdb_ci_appl_hp_service,cmdb_ci_vcenter,cmdb_ci_interconnect_instance,cmdb_ci_app_simulation,cmdb_m2m_business_process_ci,cmdb_ci_ec2_instance,cmdb_ci_endpoint_peoplesoft,cmdb_multisource_column_type_mapping,cmdb_ci_endpoint_iis,cmdb_ci_iscsi_disk,cmdb_ci_vcenter_datacenter,cmdb_ci_appl_now_app_comp,cmdb_ci_appl_tibco_message,cmdb_ci_unix_cluster,cmdb_qb_table_mapping,cmdb_ci_kvm_storage_pool,cmdb_ci_netgear,cmdb_ci_win_cluster_node,cmdb_ci_appl_cisco_call_man,cmdb_ci_exchange_hub,cmdb_ci_storage_container,cmdb_health_scorecard,cmdb_health_orphan_rule,cmdb_ci_appl_rabbitmq,cmdb_ci_unix_cluster_node,cmdb_ci_endpoint_imap,cmdb_ci_hyper_v_object,cmdb_ci_vm_vmware,cmdb_ci_endpoint_hpom,cmdb_ci_endpoint_sap_db,cmdb_rel_attributes,cmdb_ci_appl_vignette_search,cmdb_ci_app_server_jrun,cmdb_ci_exchange_edge_transport_server,cmdb_ci_cloud_public_ipaddress,cmdb_ip_address_pool,cmdb_ci_storage_mapping,cmdb_ci_appl_wmb,cmdb_ire_output_comparison,cmdb_ci_endpoint_block,cmdb_db_option,cmdb_ci_lb_a10,cmdb_ci_appl_sap_server,cmdb_ci_appl,cmdb_ci_host_cluster,cmdb_ci_endpoint_tomcat_war,sn_cmdb_ws_attestation_task_to_ci,cmdb_ci_cluster_node,cmdb_health_scorecard_service,cmdb_ci_appl_license_server,cmdb_ci_web_application,cmdb_ci_apic_host,cmdb_ci_bridge_domain,cmdb_ci_computer,cmdb_ci_ids_network,cmdb_ci_oslv_container,cmdb_ci_endpoint_acl,cmdb_ip_address_range,cmdb_ci_cloud_storage_account,cmdb_ci_spkg,cmdb_ci_storage_switch,cmdb_ci_routing_policy,cmdb_ci_lb_datacenter,cmdb_ci_qualifier_external_connection,cmdb_ire_incomplete_payloads0004,cmdb_ci_cloud_appserver,cmdb_ci_win_server,cmdb_ci_endpoint_ems_jndi,cmdb_group_contains_ci,cmdb_ci_mainframe,cmdb_resource_location,cmdb_multisource_data,cmdb_ci_win_domain_controller,cmdb_ci_websphere_cell,cmdb_ci_route,cmdb_ci_endpoint_ssas,cmdb_ci_inetinfo,cmdb_ci_tower_light_tower_eq,cmdb_ci_mpio_pool,cmdb_ci_internet_gateway,cmdb_ci_fddi_network,cmdb_ire_incomplete_payloads0003,cmdb_ci_azure_datacenter,cmdb_ci_lb_f5_gtm,cmdb_ci_endpoint_biztalk_orch,cmdb_ci_wbem_service,cmdb_ci_installed_bundles,cmdb_ci_virtualization_server,cmdb_ci_vserver_peer,cmdb_ci_endpoint_inclusion,cmdb_ci_san_fabric,cmdb_ci_wap_network,cmdb_model,cmdb_ci_mainframe_hardware,cmdb_ci_appl_hp_operations,cmdb_ci_endpoint_aq_queue,cmdb_ci_endpoint_oracle_ias,cmdb_ci_database,cmdb_ci_endpoint_oracle_esb,cmdb_ci_appl_tibco_queue,cmdb_ci_db_db2_instance,cmdb_health_config,cmdb_ci_endpoint_ejb,cmdb_ci_endpoint_tbco_confile,cmdb_ci_endpoint_manual,cmdb_ci_endpoint_agility,cmdb_ci_san,cmdb_software_product_model,cmdb_ci_file_system,cmdb_ci_appl_generic,cmdb_ci_exchange_backend,cmdb_ci_endpoint_mq_mem,task_cmdb_ci_service,cmdb_group_type,cmdb_ci_net_app_server,cmdb_ci_pc_hardware,cmdb_ire_output_target_item,cmdb_ci_endpoint_tibco_bw_proc,cmdb_ci_printing_hardware,cmdb_ci_service_business,cmdb_ci_docker_engine,cmdb_ci_cloud_directory,cmdb_ci_customer_gateway,cmdb_ci_endpoint_ajp,cmdb_data_management_task_to_ci,cmdb_ci_endpoint_network,cmdb_ci_appl_sap_bus_obj,cmdb_ci_db_mysql_instance,cmdb_ci_storage_disk,cmdb_ci_service,cmdb_kvm_device,cmdb_sw_license_calculation,cmdb_multisource_query,cmdb_ci_nas_file_system,cmdb_ci_netware_server,cmdb_ci_environment,cmdb_data_management_policy_execution,cmdb_ci_endpoint_mq_flow,cmdb_ci_veritas_subdisk,cmdb_ci_email_server,cmdb_ci_appl_ora_notif_svr,cmdb_ci_display_hardware,cmdb_ci_beacon_tower_eq,cmdb_ci_csu_dsu_network,cmdb_ci_appl_sap_system,cmdb_ci_cloud_monitor_notification,cmdb_ci_endpoint_fastsearch,cmdb_ci_router,cmdb_ci_lpar,cmdb_ci_solaris_instance,cmdb_ci_appl_ibm_wmb_listener,cmdb_ci_vm_user_credentials,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_storage_fileshare,cmdb_ci_ip_switch,cmdb_baseline,cmdb_facility_model_lifecycle,cmdb_multisource_query_result_ms_record,cmdb_metadata_reference,cmdb_db_tablespace,cmdb_ci_dir_policy_server,cmdb_ie_log,cmdb_ci_cloud_key_pair,cmdb_fc_target,cmdb_ci_appl_ora_forms,cmdb,cmdb_ci_personal_printer,cmdb_ci_endpoint_oracle_tns,cmdb_ci_os_template,cmdb_ci_db_mssql_database,cmdb_model_category,cmdb_ci_route_table,cmdb_peer,cmdb_properties,cmdb_ci_end_of_life_ledger,cmdb_ci_san_zone,cmdb_ci_qtree,cmdb_ci_storage_controller,cmdb_ci_rack,cmdb_ci_hpux_server,cmdb_ci_monitoring_hardware,cmdb_ci_netapp_cdot,cmdb_ci_appl_rabbitmq_cluster,cmdb_ci_app_server_vendavo,cmdb_ci_imaging_hardware,cmdb_ci_oslv_image_tag,cmdb_ci_sa_scaling_pol_base,cmdb_ci_storage_vol_snapshot,cmdb_ci_appl_sap_ci,cmdb_ci_datacenter,cmdb_health_result_group_map,cmdb_ci_cloud_topic,cmdb_ci_endpoint_ssis,cmdb_ci_appl_weblogic_jms,cmdb_ci_sun_dir_proxy_server,cmdb_ci_appl_itam,cmdb_ci_app_server_datapower,cmdb_dynamic_ire_model,cmdb_ci_appl_sendmail,cmdb_ci_endpoint_sim_inc,cmdb_ci_app_server_wl_module,cmdb_ci_availability_zone,cmdb_ci_db_instance,cmdb_ci_app_server_weblogic,cmdb_ire_incomplete_payloads0001,cmdb_ci_exchange_mailbox_server,cmdb_ci_endpoint_sap_bo_servers,cmdb_ci_apache_web_server,cmdb_ci_endpoint_ent_vault,cmdb_ci_appl_ora_report,cmdb_ci_appl_biztalk_orch,cmdb_ci_power_eq,cmdb_ci_ip_address,cmdb_dynamic_ire_filter_condition,cmdb_ci_sun_ldap_dir_server,cmdb_ci_fc_disk,cmdb_ci_hyper_v_rpool_comp,cmdb_ci_nas_storage,cmdb_ci_hyper_v_cluster,cmdb_ci_db_ora_catalog,cmdb_ci_lb_ace,cmdb_ci_config_automation_server,cmdb_data_management_task,cmdb_ci_dc_plant_battery_pwr,cmdb_ci_appl_ibm_ctg,cmdb_ci_application_cluster,cmdb_ci_endpoint_ms_sql,cmdb_lease,cmdb_ci_computer_room,cmdb_ci_cim_server,cmdb_ci_endpoint_intgateway,cmdb_ci_comm,cmdb_reconciliation_definition,cmdb_ci_lb_bigip,cmdb_dependent_ci_ledger,cmdb_dynamic_reconciliation_definition,cmdb_ci_app_server_ora_ias_m,cmdb_fixup,cmdb_ci_dc_plant_eq_power_eq,cmdb_ci_endpoint_oracle_db,cmdb_ci_lb_appl,cmdb_inst_application_feed,cmdb_ci_appl_msmq,cmdb_ci_storage_export,cmdb_tcp_half,cmdb_volume_security_style,cmdb_group,cmdb_health_scorecard_group,cmdb_ci_endpoint_oracle_rac,cmdb_ci_lb_modjk,cmdb_ci_vpn,cmdb_ci_app_server_websphere,cmdb_ci_drs_vm_config,cmdb_ci_endpoint_nfs,cmdb_ci_endpoint_wmb_flow,cmdb_ci_lb_listener,cmdb_ci_wan_accel_network,cmdb_ci_virtual_desktop,cmdb_ci_network_template,cmdb_ci_veritas_disk,cmdb_ci_ups_alarm,cmdb_ci_appl_ibm_cics,cmdb_ci_appl_controlm,cmdb_ci_memory_module,cmdb_ci_endpoint_nat,cmdb_ci_appl_fastsearch,cmdb_ci_customization_spec,cmdb_ci_application_software,cmdb_ci_appl_ca_id_man,cmdb_ci_docker_local_image,cmdb_ci_oslv_image,cmdb_ci_lb_template,cmdb_ci_appl_vign_content_svr,cmdb_multisource_recomp_task_ci,cmdb_related_entry,cmdb_health_result_rel_all,cmdb_ci_schedule_policy_template,cmdb_ci_appl_ora_ebs,cmdb_ci_crac,cmdb_rel_ci,cmdb_ci_fc_port,cmdb_ci_storage_cluster_node,cmdb_ci_appl_ora_jms_queue,cmdb_datasource_staleness,cmdb_ci_appl_tibco_hawk,cmdb_tcp,cmdb_ci_kvm,cmdb_ci_vm,cmdb_environment_to_ci,cmdb_ci_compute_template,cmdb_ci_business_capability,cmdb_ci_vm_zones,cmdb_ci_db_db2_catalog,cmdb_ci_endpoint_ad_domain,cmdb_ci_endpoint_db2sql,sn_cmdb_ws_group_metadata,cmdb_ci_appl_sap_hana_db,cmdb_ci_vcenter_dv_port_group,cmdb_ci_endpoint_ctg,cmdb_ip_service,cmdb_ci_appl_ora_http,cmdb_ci_storage_pool_member,cmdb_ci_iisdirectory,cmdb_ci_hardware,cmdb_ci_resource_group,cmdb_multisource_recomp_task,cmdb_ci_ucs_rack_unit,cmdb_health_processor_status,cmdb_lb_service_vlan,cmdb_print_queue_instance,cmdb_convert_bulk_services,cmdb_ci_unix_cluster_resource,cmdb_ci_appl_tibco_matrix_proc,cmdb_hardware_product_model,cmdb_ci_logical_datacenter,cmdb_view_instance,cmdb_ci_app_server_dp_domain,cmdb_ci_lb_nginx,cmdb_ci_bundled_resources,cmdb_ci_win_cluster_resource,cmdb_inst_entity,cmdb_ci_endpoint_exchange,cmdb_health_scorecard_group_threshold,cmdb_ci_vmware_template,cmdb_ci_app_server_ws_ear,cmdb_ci_app_server,cmdb_ci_endpoint_ftp,cmdb_ci_endpoint_route_table,cmdb_ire_output_comparison_item,cmdb_serial_number,cmdb_ci_generator_power_eq,cmdb_ci_circuit,cmdb_ci_endpoint_dctm_index,cmdb_ci_endpoint_mysql_slave,cmdb_ci_appl_sap,cmdb_ci_appl_ora_forms_ui,cmdb_ci_hyper_v_network,cmdb_ci_print_queue,cmdb_ci_cloud_subnet,cmdb_ci_snapshot_template,cmdb_ci_network_policy_group,cmdb_ci_app_server_jb_module,cmdb_hardware_model_lifecycle,cmdb_ci_storage_volume,cmdb_ci_endpoint_xenapp_citrx,cmdb_ci_translation_rule,cmdb_ci_ucs_equipment,cmdb_ci_lb_pool,cmdb_ci_endpoint_ob_cluster,cmdb_ci_appl_doc_brava_proc,cmdb_ci_appl_connectit,cmdb_ci_ip_server,cmdb_ci_endpoint_ssis_mssql,cmdb_running_process,cmdb_ci_ucs_blade,cmdb_ci_datastore,cmdb_ci_endpoint_jboss,cmdb_ci_ip_phone,cmdb_ci_sa_dynamic_policy,cmdb_application_product_model,cmdb_ci_lb_modproxy,cmdb_ci_solaris_server,cmdb_ci_network_acl_rule,cmdb_policy_scheduled_job,cmdb_ci_iplanet_web_server,cmdb_ci_vcenter_datastore_disk,cmdb_ci_endpoint_inclusion_rabbitmq_queue,cmdb_ci_endpoint_sharepoint_service,cmdb_ci_app_server_tomcat_war,cmdb_ie_context,cmdb_ci_lvm_pool,cmdb_ci_dns_name,cmdb_ci_epic_cache,cmdb_ire_partial_payloads,cmdb_ci_endpoint_xenapp_comp,cmdb_ci_endpoint_cust_gateway,cmdb_ci_endpoint_subnet,cmdb_ci_endpoint_oracle_db_schema,cmdb_ci_endpoint_docbase,cmdb_class_relationships,cmdb_ci_appl_sap_di,cmdb_ci_app_server_ws_odr,cmdb_ci_appl_ora_queue,cmdb_ci_printer,cmdb_ci_ups_power_eq,cmdb_ci_app_server_java,cmdb_ci_file_system_nfs,cmdb_ci_service_technical,cmdb_ci_query_based_service,cmdb_ci_cluster_vm_host_rule,cmdb_ci_db_ora_listener,cmdb_rel_filter,cmdb_ci_appl_hp_qc,temp_cmdb_ci_disk,cmdb_ire_incomplete_payloads0005,cmdb_ci_app_server_hp_ucmdb,cmdb_ci_appl_sap_bo,cmdb_ci_endpoint_f5,cmdb_ci_endpoint_smtp,cmdb_ci_cim_profile,cmdb_ci_endpoint_storefront_components,cmdb_ci_appl_websphere_portal,cmdb_ci_unix_server,cmdb_ci_kvm_storage_volume,cmdb_pid,cmdb_class_user_preference,cmdb_ci_hyper_v_server,cmdb_multisource_deny_class,cmdb_ci_lb_cisco_css,cmdb_ci_endpoint_storf,cmdb_rel_group_type,cmdb_health_result_service_map,cmdb_ie_active_config,cmdb_ci_cluster_vm_affinity_rule,temp_cmdb_ci_file_system,cmdb_ci_endpoint_epicd,cmdb_ci_config_file,cmdb_ci_config_file_tracked,cmdb_ci_db_mysql_clustermgnode,cmdb_ci_ip_firewall,cmdb_ci_server_snapshot,cmdb_ci_cloud_ip_address,cmdb_ci_cluster,cmdb_ci_endpoint_app_storage,cmdb_ci_endpoint_vm_esx,cmdb_ci_ups,cmdb_ci_appl_glassfish,cmdb_ci_compute_security_group,cmdb_ire_incomplete_payloads0006,cmdb_policy_type_categories,statemgmt_cmdb_actions,cmdb_fc_initiator,cmdb_ci_exchange_hub_transport_server,cmdb_ci_peripheral,cmdb_ci_lif,cmdb_ci_appl_ora_disc,cmdb_ci,cmdb_ci_ups_input,cmdb_ci_appl_ca_dir_server,cmdb_ip_service_ci,cmdb_ci_san_endpoint,cmdb_qb_result_base$par1,cmdb_ci_app_network_profile,cmdb_ci_endpoint_http,cmdb_ci_lb_cisco_gss,cmdb_ci_endpoint_fromcluster_t,cmdb_multisource_column_metadata,cmdb_ci_endpoint_router,cmdb_ci_kvm_vm_instance,cmdb_ci_veritas_volume,cmdb_ci_web_site,cmdb_ci_appl_hp_sm_kb,cmdb_health_metric,cmdb_ci_service_group,cmdb_ci_lb_netscaler,cmdb_ci_vm_instance,cmdb_ci_netapp_volume,cmdb_ci_endpoint_jrun,cmdb_ci_exchange_frontend,cmdb_ci_san_zone_alias,cmdb_ci_endpoint_tcp,cmdb_ci_appl_ora_tnslsnr,cmdb_ci_tower_tower_eq,cmdb_metadata_containment,cmdb_ci_endpoint_jms_queue,sn_cmdb_ws_group_query_metadata,cmdb_health_metric_status,cmdb_ci_cloud_lb_ipaddress,cmdb_cloud_mgmt_credentials,cmdb_ci_cloud_messaging_service,cmdb_ci_exchange_cas,cmdb_ci_appl_ora_tns,cmdb_ci_lvm_pool_member,cmdb_ci_app_server_jrun_war,cmdb_ci_qualifier,cmdb_ci_qualifier_hidden_conn,cmdb_ci_ups_output,cmdb_ci_appl_ora_conc,cmdb_ci_puppet_master,cmdb_ci_endpoint_iifp,cmdb_group_contains_encoded_query,cmdb_ci_zone,cmdb_ci_business_app,cmdb_ci_appl_sp_service,cmdb_ci_unix_daemon,cmdb_ci_cloud_database,cmdb_instance_run_history,cmdb_ci_app_server_jboss,cmdb_ci_ad_domain,cmdb_ci_disk_partition,cmdb_ci_db_mysql_clusternode,cmdb_group_event_queue,cmdb_ci_endpoint_listener_wmb,cmdb_ci_vcenter_dvs,cmdb_ci_business_process,cmdb_ci_appl_doc_docbroker,cmdb_rel_type_rule_definitions,cmdb_ci_endpoint,cmdb_ci_endpoint_itam,cmdb_ci_appl_ora_fs,cmdb_ci_service_calculated,cmdb_ci_storage_pool,cmdb_software_instance,cmdb_ci_san_export,cmdb_ire_incomplete_payloads0002,cmdb_m2m_model_substitute,cmdb_ci_endpoint_jms_server,cmdb_ci_dns_alias,cmdb_ci_vcenter_vm_group,cmdb_ci_endpoint_mysql_server,cmdb_ci_volume_template,cmdb_ci_app_server_domino,cmdb_secondary_volume,cmdb_discovery,cmdb_ire_partial_payloads_index,cmdb_recommended_fields,cmdb_ci_alias,cmdb_rel_type,cmdb_ci_appl_ibm_wmq_queue,cmdb_ci_cluster_resource,cmdb_ci_endpoint_ldap,cmdb_ci_appl_citrix_xenapp,cmdb_ci_docker_image,cmdb_ci_ip_router,cmdb_ci_appl_tibco_matrix,cmdb_ci_ftp_server,cmdb_ci_dir_site_minder_server,cmdb_ci_appl_sap_bo_scheduler,cmdb_ci_raid_member,cmdb_ci_cloud_load_balancer,cmdb_ci_exchange_service_component,cmdb_ci_infra_service,cmdb_ci_endpoint_crm,cmdb_ci_sa_launch_config,cmdb_ci_app_server_tomcat,cmdb_ci_cmp_resource,cmdb_ci_endpoint_ms_sql_server,cmdb_health_staleness_rule,cmdb_ci_appl_ora_metric_client,cmdb_ci_storage_node_element,cmdb_ci_endpoint_inter_connect,cmdb_ci_endpoint_ssis_job,cmdb_ci_lb_service,cmdb_ci_ucs_chassis,cmdb_ci_endpoint_extnetwork,cmdb_ci_endpoint_dctm_broker,cmdb_ci_endpoint_ldap_db,cmdb_ci_vmware_nic,cmdb_m2m_model_compatibility,cmdb_ci_endpoint_mapi_hub,cmdb_ci_server,cmdb_ci_db_mssql_catalog,cmdb_ci_appl_tuxedo,cmdb_ci_appl_doc_docbase,cmdb_ci_web_server,cmdb_ci_nginx_web_server,cmdb_tcp_connection,cmdb_ci_agility_process,cmdb_ci_endpoint_sp_connection,cmdb_ci_qualifier_manual_ci_endpoint,cmdb_ci_vcenter_datastore,cmdb_ci_pdu,cmdb_ci_endpoint_rfc,cmdb_ci_windows_service,cmdb_ci_isam_server,cmdb_ci_email_server_jes,cmdb_convert_bulk_services_entry,cmdb_ci_appl_dot_net,cmdb_ci_inter_connect,cmdb_ci_endpoint_mapi,cmdb_model_lifecycle,cmdb_ci_endpoint_ad_service_in,cmdb_ci_tomcat_connector,cmdb_ci_fc_export,cmdb_ci_endpoint_remote_tcp,cmdb_group_contains_qb_query,cmdb_ci_endpoint_pop3,cmdb_ci_file_system_smb,cmdb_ci_cluster_vip,cmdb_printer_instance,cmdb_ci_qualifier_entrypoint,cmdb_ci_kvm_network,cmdb_ci_port_group,cmdb_ci_os_packages,cmdb_ci_endpoint_sim_flow,cmdb_health_result_count,cmdb_ci_sa_simple_policy,cmdb_m2m_suite_model,cmdb_model_unit_conversion,cmdb_ci_port,cmdb_ci_vpc,cmdb_ci_directory_ad_forest,cmdb_multisource_query_result_diff_record,cmdb_ci_directory_ldap,task_cmdb_ci_business_app,cmdb_ci_remote_backup_template,cmdb$par1,cmdb_alias,cmdb_ci_esx_resource_pool,cmdb_ci_vcenter_object,cmdb_ci_endpoint_app,cmdb_volume_autosize_mode,cmdb_ci_oslv_engine,cmdb_ci_endpoint_mq,cmdb_ci_endpoint_mysql_cl_mg,cmdb_service_product_model,cmdb_ci_nic,cmdb_ci_db_hbase_instance,cmdb_dependent_ci_class_exclusion,cmdb_ci_storage_access_policy,cmdb_ci_lb_backend_server,cmdb_ci_mpio_pool_path,cmdb_ie_run,cmdb_consumable_model_lifecycle,cmdb_m2m_model_component,cmdb_baseline_entry,cmdb_ci_patches,cmdb_ci_lb_vlan,cmdb_ci_web_domino,cmdb_ci_appl_sharepoint,cmdb_ip_address_dns_name,cmdb_ci_appl_mongos,cmdb_ci_vcenter_server_obj,cmdb_ci_group,cmdb_datasource_precedence,cmdb_ci_endpoint_ems,cmdb_ci_db_syb_catalog,cmdb_ci_docker_container,cmdb_ci_appl_ora_metric_svr,cmdb_ci_epicd_app_server,cmdb_ci_acc,cmdb_multisource_query_status,cmdb_application_model_lifecycle,cmdb_ci_network_adapter,cmdb_health_metric_pref,cmdb_policy_type,cmdb_ci_appl_glassfish_war,cmdb_class_info,cmdb_rel_rollup,cmdb_ci_protection_template,cmdb_ci_net_app_host,cmdb_ci_storage_cluster,cmdb_ci_db_mssql_analysis,cmdb_ci_endpoint_j2ee_ear,cmdb_ci_scanner,cmdb_ci_lb_f5_ltm,cmdb_ci_app_server_remedy,cmdb_ci_endpoint_wmb_depend,cmdb_ci_endpoint_ssas_mssql,cmdb_ci_facility_hardware,cmdb_ci_tower_eq,cmdb_ci_twr_light_cnt_tower_eq,cmdb_ci_endpoint_mq_queue,cmdb_ci_oslv_local_image,cmdb_ci_netapp_datacenter,cmdb_ci_app_server_composer,cmdb_ci_net_traffic,cmdb_ci_lb_radware,cmdb_ci_raid,cmdb_ci_openstack_datacenter,cmdb_ci_endpoint_storage_fc,cmdb_ci_qualifier_boundary_connection,cmdb_ci_endpoint_tibco_hawk,cmdb_ci_vpn_connection,cmdb_ci_ad_controller,cmdb_ci_endpoint_aq,cmdb_ci_endpoint_tibco_bw,cmdb_ci_security_grp_template,cmdb_ci_lb_pool_member,cmdb_contract_product_model,cmdb_ci_appl_ora_pm,cmdb_ci_service_discovered,cmdb_ci_chassis_server,cmdb_ci_endpoint_biztalk,cmdb_ci_network,cmdb_ci_surge_power_eq,cmdb_ci_appl_ora_disc_ui,cmdb_categories,cmdb_job_context,cmdb_ci_lb_cisco_csm,temp_cmdb_ci_storage_port,cmdb_subscriber,cmdb_ci_db_ora_instance,cmdb_ci_appl_hp_index,cmdb_ci_db_catalog,cmdb_ci_information_object,cmdb_ci_appl_citrix_collector,cmdb_identifier_entry,cmdb_ci_modem_network,cmdb_ire_incomplete_payloads0000,cmdb_ci_vcenter_network,cmdb_datasource_attribute_value,cmdb_health_source_precedence,cmdb_ci_endpoint_ssis_file,cmdb_ci_appl_sap_scs,cmdb_ci_vcenter_cluster,cmdb_ci_qualifier_manual_connection,cmdb_ci_app_server_ora_ias,cmdb_ci_iscsi_export,cmdb_ci_storage_def_template,cmdb_ci_server_hardware,cmdb_ci_appl_ibm_wmb,cmdb_ci_outofband_device,cmdb_ci_sa_server_array,cmdb_ci_model_entry,cmdb_rel_person,cmdb_ci_batch_job,cmdb_ci_appl_vignette_server,cmdb_ci_storage_port,cmdb_multisource_query_result_disco_source,cmdb_ci_ip_device,cmdb_ci_veritas_plex,cmdb_ci_endpoint_sap_bo_srv,cmdb_ci_switch,cmdb_outage_ci_mtom,cmdb_health_scorecard_threshold,cmdb_ci_db_mssql_instance,cmdb_ci_virtual_pvt_gateway,cmdb_dynamic_ire_feature_set,cmdb_ci_email_server_ent_vault,cmdb_ci_appl_ca_ent_man,cmdb_ci_mirror_template,cmdb_inst_application,cmdb_ci_vcenter_host_group,cmdb_health_top_task_generating_cis_scorecard,cmdb_ci_ip_service,cmdb_ci_cloud_resource_base,cmdb_ci_appl_groundwork,cmdb_storage_accesspolicy_rule,cmdb_ci_storage_hba,cmdb_ci_hyper_v_resource_pool,cmdb_ci_endpoint_ebs,cmdb_ci_fuel_tank,cmdb_health_result,cmdb_ci_veritas_disk_group,cmdb_key_value,cmdb_ci_san_zone_member,cmdb_ci_vm_parallels,cmdb_data_management_policy,cmdb_ci_vcenter_folder,cmdb_ci_endpoint_iscsi,cmdb_ci_aws_account,cmdb_dynamic_ire_match,cmdb_ci_cluster_node_resource,cmdb_ci_app_simulation_inc,cmdb_ire_output_aggregate_stats,cmdb_ci_app_server_ora_ess,cmdb_ci_appl_cisco_fibre,cmdb_ci_appl_ca,cmdb_import_set_run,cmdb_ci_appl_tuxedo_portal,cmdb_ci_azure_subscription,cmdb_ci_msd,cmdb_ci_db_postgresql_instance,cmdb_ci_endpoint_sap,cmdb_ci_microsoft_iis_web_server,cmdb_ci_ip_network,cmdb_ire_data_source_rule,cmdb_depreciation,cmdb_ci_endpoint_mysql_cl_dn,cmdb_ci_appl_weblogicmodule,cmdb_ci_appl_ora_oafm,cmdb_ci_mfp_printer,cmdb_dedup_default_rel_item,cmdb_ci_lb_network,cmdb_ci_endpoint_dliver_cnrl,cmdb_ci_san_zone_set,nlq_cmdb_implicit_relationship,cmdb_ci_endpoint_msmq,cmdb_ci_endpoint_vnic,cmdb_ci_endpoint_sap_app,cmdb_ci_inf_software,cmdb_datasource_last_update,cmdb_reconciliation_definition_mapping,cmdb_rel_group,cmdb_ci_desktop_software,cmdb_ci_endpoint_glassfish_war,cmdb_ci_availability_set,cmdb_ci_lb_interface,cmdb_ci_exchange_mailbox,cmdb_ci_san_zone_alias_member,cmdb_ci_appl_ibm_wmq,cmdb_ci_endpoint_ad_forest,cmdb_multisource_query_result,cmdb_related,cmdb_ci_tape_server,cmdb_ci_app_server_webseal,cmdb_ci_cloud_monitor_alarm,cmdb_identifier,cmdb_ci_endpoint_ems_queue,cmdb_ci_appl_now_app,cmdb_ci_disk,cmdb_ci_appl_tibco_adapter,cmdb_ci_hub_network,cmdb_ci_endpoint_sybase,cmdb_ci_cluster_vm_dependency_rule,cmdb_ci_appl_peoplesoft,cmdb_ci_apic_tenant,cmdb_ci_endpoint_nntp,cmdb_m2m_downgrade_model,cmdb_consumable_product_model,cmdb_model_unit,cmdb_ci_mainframe_lpar,cmdb_ci_appl_sap_jc,cmdb_ci_infra_service_ldap,cmdb_os_user,cmdb_ci_endpoint_xenapp,cmdb_metadata_hosting,cmdb_ci_lb_haproxy,cmdb_ci_web_service,cmdb_facility_product_model,cmdb_ci_appl_ms_dynamic_crm,cmdb_ci_kvm_object,cmdb_ci_lb,cmdb_ci_appl_sap_ers,cmdb_ci_building_facility,cmdb_ci_db_mssql_integration,cmdb_rel_type_suggest,cmdb_ci_mpio_pool_group,cmdb_ci_endpoint_cloud_db_instance,cmdb_ci_ups_bypass,cmdb_switch_port,cmdb_ci_pdu_outlet,cmdb_ci_vmware_instance,cmdb_ci_state_management_task_to_ci,cmdb_ci_endpoint_comp_security,cmdb_rel_team,cmdb_ci_snat_ip_pool,cmdb_ci_outage,cmdb_duplicate_ci_remediation,cmdb_ci_appl_mongo_config_serv,cmdb_ci_osx_server,cmdb_ci_aix_server,cmdb_ci_db_mssql_int_job,cmdb_ci_cloud_host,cmdb_ci_subnet,cmdb_ci_vm_object,cmdb_ci_endpoint_tibco_file,cmdb_ci_endpoint_storefront_comp,cmdb_contract_model_lifecycle,cmdb_ci_lb_alteon,cmdb_ci_datapower_server,cmdb_ci_win_cluster,cmdb_ci_appl_biztalk
*** Script: Table length 909

Regards,Shamma Negi

Prabhjot Kaur4 · ‎12-07-2023

Hi,

You can go to Parent CMDB class by using "cmdb.LIST" and then group by class name.

It will give you the count of CIs for each CI table.

Thanks

Prabhjot