OTRS CMDB Storage

English! place to talk about OTRS development, programming and coding

Moderator: tto

Post Reply
mohsinkhan009
OTRS newbie
Posts: 40
Joined: 02 Sep 2015, 08:47
OTRS Version?: OTRS-Rel-5

OTRS CMDB Storage

Post by mohsinkhan009 » 12 Sep 2018, 13:18

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
OTRS superhero
Posts: 216
Joined: 15 Dec 2016, 15:13
OTRS Version?: 3.x - 6.0.x
Real Name: Emin
Company: maxence business consulting GmbH
Contact:

Re: OTRS CMDB Storage

Post by zzz » 12 Sep 2018, 13:28

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

mohsinkhan009
OTRS newbie
Posts: 40
Joined: 02 Sep 2015, 08:47
OTRS Version?: OTRS-Rel-5

Re: OTRS CMDB Storage

Post by mohsinkhan009 » 12 Sep 2018, 14:36

Thanks Emin,

For your Quick reply...

regards,
Mohsin khan

Post Reply