Can we use cmdb_ci without any filter for fetching organization-managed device data? Also, confirm if this table only contains device data.
If we needed to use a filter, what would it be?
As per our analysis, we can use sys_class_name as a filter with a list of class names we have listed.
We have listed below tables or classes (this list can be extended)
['cmdb_ci_display_hardware', 'cmdb_ci_peripheral', 'cmdb_ci_ip_phone', 'cmdb_ci_ip_device', 'cmdb_ci_msd', 'cmdb_ci_personal_printer', 'cmdb_ci_plotter', 'cmdb_ci_outofband_device', 'cmdb_ci_printing_hardware', 'cmdb_ci_computer', 'cmdb_ci_storage_switch', 'cmdb_ci_imaging_hardware', 'cmdb_ci_storage_device', 'cmdb_ci_comm', 'cmdb_ci_pc_hardware', 'cmdb_ci_ip_switch', 'cmdb_ci_hardware', 'cmdb_ci_firewall_network', 'cmdb_ci_mainframe_hardware', 'cmdb_ci_ip_router', 'cmdb_ci_switch', 'cmdb_ci_printer']
Also, to check if we have access to these classes, we need to make an API call to each class or table. Is there any other way to validate all the tables in a single API call?
Or
We can identify columns used to store device data and filter, and if these filtered columns have data, then we can fetch it; otherwise, we can skip.
If so, what columns are used to store device data?
Or
Is there any other filter that can be used?
