Tables CMDB for query

[candres28]

I want to make it through a query bring all the information of the cmdb por example in which table in which table I find "configuration item version details"

[RStraub]

Hey there,

I doubt you'll be happy with the DB structure of the CI-storage. It might be easier to use the API and a custom Perl script.
Here is an example to query all entries for a config item with ID 2551:

Code: Select all

select * from xml_storage where xml_key = 2551;

You might want to filter:

Code: Select all

and xml_type like 'ITSM::ConfigItem%'