OTRS CMDB Storage

English! place to talk about development, programming and coding
Post Reply
mohsinkhan009
Znuny newbie
Posts: 64
Joined: 02 Sep 2015, 08:47
Znuny Version: OTRS-Rel-5

OTRS CMDB Storage

Post by mohsinkhan009 »

Hi All,

I want to know where exactly the CMDB data is store as I check the database their all the data is not getting store.
for eg.
i want to know where the below value pick by OTRS

Name: Laptop
Deployment State: Maintenance
Incident State: Operational
Vendor: Dell
Model: Dell
Description: OS -10
Type: Laptop
Owner: customer name
Serial Number: 111111111111111
Operating System: 10
CPU:
CPU:
Ram:
Hard Disk:

regards,
Mohsin khan
zzz
Znuny superhero
Posts: 888
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: OTRS CMDB Storage

Post by zzz »

Hello Mohsin,

they are stored in `xml_storage` and in `configitem*`.

Query:
SELECT *
FROM `xml_storage`
WHERE xml_type LIKE 'ITSM::ConfigItem::%';


This database structure makes developing unnecessarily complex.

Best regards
Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
mohsinkhan009
Znuny newbie
Posts: 64
Joined: 02 Sep 2015, 08:47
Znuny Version: OTRS-Rel-5

Re: OTRS CMDB Storage

Post by mohsinkhan009 »

Thanks Emin,

For your Quick reply...

regards,
Mohsin khan
Post Reply