Which CMDB table to query if I need to extract all CIs irrespective of CI types ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2020 02:54 AM
Hi,
I would need to extract all CIs (Irrespective of CI class or category) from my instance through REST call. Which table should I query to get all CIs and their relationships at once ?
Is it cmdb_ci and cmdb_rel_ci ?
OR
If I need to fetch Application server then I need to provide table name as cmdb_ci_appl ?
If I need to fetch Database server then I need to provide table name as cmdb_ci_database ? etc...
Please let me know your valuable inputs regarding the same.
Regards,
Avi

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2020 04:02 AM
Hi,
There are few attributes created on specific tables and not on cmdb_ci. In that case you need to query respective tables.
When you say download means in excel or just api calls?
We use Export sets if we wont whole dump of CMDB.
Thanks,
Ashutosh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2020 04:07 AM
You could query the cmdb_ci table. This is the parent table for all the CIs.